Criteria based sum question
Total resources for Project A
=sumproduct(--(C1:C100="A"),--(B1:B100))
Regular resources for Project A
=Sumproduct(--(A1:A100="Regular"),--((--(C1:C100="A"),--(B1:B100))
HTH
"masik" wrote:
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.
|