SUMIF with two criteria??

[Potatosalad2]

I would like to sum values for all rows where the value in column B
'F' AND the value in column C = 'X' I don't seem able to use SUMIF whe
I have 2 criteria that need to be met for summing as opposed to jus
one. Any advice would be greatly appreciated. Chas

 

[Chip Pearson]

Use the SUMPRODUCT function:

=SUMPRODUCT(--(B1:B100="F"),--(C1:C100="X"),D1100)

change the D1100 to the range containing the values you want to
sum.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Potatosalad2"
in message
news[email protected]...

 

[Bob Phillips]

=SUMPRODUCT(--(C2:C200="X"),--(B2:B200="F"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Potatosalad2" <[email protected]>
wrote in message
news[email protected]...

 

[Potatosalad2]

Thank you very much. This is exactly what i needed.