Sumif base on 2 criteria

J

Joe Rotondo

I am having problems coming up with a sumif formula based
on two conditions. I have three columns. Column A =
client #, Column B = work code, and Column C = hours. I
am looking for a sumif formulat that will calculate the
total hours worked for employees working on (for example)
Client #387 and work code 88. Please help if you know
how to do this. thanks.

Joe
 
D

Dave R.

Hi Joe;

use sumproduct for this;

=SUMPRODUCT((A1:A100=387)*(B1:B100=88),C1:C100)

I am assuming 387 and 88 are NUMBERS. If not, enclose them in ""s.
 
Top