Sumif base on 2 criteria

[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

 

[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.

 

[jeff]

HI,

refer to this thread by Expert Frank Kabel:

Subject: Re: Array formula problem
From: "Frank Kabel" <[email protected]> Sent:
5/5/2004 10:19:23 AM


jeff