MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 540|Reply: 12

Creating Formulas/Functions When Drop Down Boxes Are involved

[Copy link]

1

Topics

1

Posts

11

Integral

Member

Rank: 2

Integral
11
Post on 9-30-2016 09:04:27 | All posts |Read mode
I have created a spread sheet to act as an office timesheet. It involves a few drop down boxes as below



Basically people will select the job they have been working on and the type of work they have carried out, then fill in the numbers of hours on each job every day.
I want to create a summary sheet that will total the number of hours on each job and each work type but obviously I need a formula or function that reads what has been selected in the dropdown boxes
Any advice please?




Reply

Props Report

0

Topics

6

Posts

18

Integral

Member

Rank: 2

Integral
18
Post on 9-30-2016 10:18:29 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

2

Posts

6

Integral

Newbie

Rank: 1

Integral
6
Post on 9-30-2016 15:39:16 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

5

Posts

18

Integral

Member

Rank: 2

Integral
18
Post on 9-30-2016 21:41:12 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

5

Posts

16

Integral

Member

Rank: 2

Integral
16
Post on 10-1-2016 00:29:44 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

9

Posts

24

Integral

Member

Rank: 2

Integral
24
Post on 10-1-2016 01:31:02 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

600

Posts

1384

Integral

King

Rank: 6Rank: 6

Integral
1384
Post on 10-1-2016 10:26:50 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

628

Posts

1450

Integral

King

Rank: 6Rank: 6

Integral
1450
Post on 10-1-2016 15:21:47 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

615

Posts

1422

Integral

King

Rank: 6Rank: 6

Integral
1422
Post on 10-1-2016 17:31:18 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

0

Topics

628

Posts

1444

Integral

King

Rank: 6Rank: 6

Integral
1444
Post on 10-2-2016 07:59:27 | All posts



Hi,
Pictures, and certainly pictures without any numbers, are rarely of any use. You'll need to upload the workbook. However in general you'll need to use a SUMIFS() function.
e.g.
=SUMIFS(hours_column,type_column,type_dropdown_cell,job_column,job_dropdown_cell)
Reply Support Opposition

Props Report

12Next
Return Post new threads

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-18-2017 14:13 , Processed in 0.299268 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!