Formula based on 3 criteria

C

Craig

A1 B1 C1
Location Hours Month
Essex 12 December
Kent 13 December
Surrey 32 December
Essex 13 January
Surrey 13 January
Essex 45 January
Surrey 22 January
Kent 24 January

I need a formula that picks out a location, adds up the total hours for that
location but only for a chosen month. For example from the table above i
might want to look at the total hours spent working in Essex but only in
January. In this case it would be 58 Can you help please? The answer would be
displayed in D1

Thanks
Craig
 
S

Sean Timmons

in D1...

=sumproduct(--(A2:A500="Essex"),--(c2:c500="December"),B2:B500)

will get it for you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for searching 3 different Criteria 1
Formula for searching 3 criteria 4
Update cell value based on name and specific date 1
color a range of cells based on a criteria 2
Year-to-date based on current month 2
Sum of Alternate Cells 4
Out of 12 cells in a row, I want farthest right 3
formula to look up and sum the Grand totals based on the Heading 4

Top