Criteria based sum question
All: =SUMIF(C:C,"A",B:B)
Regulars: =SUMPRODUCT(--(B2:B100="A"),--(A2:A100="Regular"),C2:C100)
Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"masik" wrote in message
...
I have data in the following format
Resource Type Resource Project
Regular 10 A
Regular 20 A
Contractor 05 A
Regular 10 B
Contractor 15 B
How would I find the sum of all resources (regular and contractor) for
project A, B, C etc. Which formula do I use? And then sum of regulars for
project A, B, C etc.
Thanks.
|