SumIF column A = x and Column B = x OR x

A

A Heeps

Does anyone know how I can use SumIf to calculate the following?

Column A Contract Hrs Cost
212 31C1 10 12
209 31C1 12 40
303 31C1 12 12
212 31C8 10 12
209 31C8 10 40
212 31A2 10 40
209 31A2 5 80

I need to be able to SUMIF Column A = (e.g.) 212 and Contract = 31C1 or
31A2, I need it to tell me the total hours

Any ideas?

Thanks
Amanda
 

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

Help with SUMIF & AND function 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Condense data for stock ordering 4
Combining 2 kinds of graphs [how?] 2
Highlight rows if column A matches but B is different 0
Sum cells using criteria from a row and a column 2
sumif with 'OR' 4
Possible? Variable X and Y data sources and Auto Charting 0

Top