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

Top