Creating Formulas/Functions When Drop Down Boxes Are involved

**troysteel99** · 09-09-2016, 11:42 AM

I have created a spread sheet to act as an office timesheet. It involves a few drop down boxes as below

Untitled-1.jpg

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?

**Richard Buttrey** · 09-09-2016, 11:56 AM

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.

Please Login or Register  to view this content.

Creating Formulas/Functions When Drop Down Boxes Are involved

LinkBack

Thread Tools

Rate This Thread

Display

Creating Formulas/Functions When Drop Down Boxes Are involved

Re: Creating Formulas/Functions When Drop Down Boxes Are involved

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Creating a Price calculator using drop down boxes for multiple BOM's

Need help in creating Drop Down Boxes with Corresponding Pricing

Creating conditional drop down boxes and then searching for selections

Creating user form with drop down list boxes

Help needed in creating a drop down list involved set of data in tables!

[SOLVED] Creating a Template with drop down boxes

Creating Drop Down boxes with the List function...

Bookmarks

Bookmarks

Posting Permissions