sum

  • Thread starter Thread starter RichardO
  • Start date Start date
R

RichardO

I hope someone can help me with the following:

I want to sum the contents in column A if Column B is "yes" and Colum
C is "Manager". How do I got about this?

Thanks in advance for your help.


RichardO
 
Thanks JE,

I thought using sumproduct in this way would COUNT the number o
entries that meet the two criteria. Am I right? I need the sum of th
entries. Can sumif do this, how do I incorporate more than 1 criteri
in the sumif range?

Thanks.

RicharO
 
=SUMPRODUCT(--(B1:B1000="yes"),--(C1:C1000="Manager))

will count yes in B where C is Manager,

=SUMPRODUCT(--(B1:B1000="yes"),--(C1:C1000="Manager),A1:A1000)

will sum A were B and C are TRUE
 
Usually (though admittedly not always) helps to try the posted solution
first...
 
Thank you JE and Peo.

I tried the formulas suggested and I am getting a #value error. Fin
my formula below:

=SUMPRODUCT(('Raw Data'!$I$1:$I$999)*('Ra
Data'!$M$1:$M$999="Yes")*('Raw Data'!$J$1:$J$999="SCI"))

Thank you for helping out.

RichardO
 
You probably have text values in I1:I999
The other option would be a value error in the same range
 
Back
Top