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

--

HTH

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


"Potatosalad2"
wrote in message
...

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 when
I have 2 criteria that need to be met for summing as opposed to just
one. Any advice would be greatly appreciated. Chas.


--
Potatosalad2
------------------------------------------------------------------------
Potatosalad2's Profile:
http://www.excelforum.com/member.php...o&userid=20834
View this thread: http://www.excelforum.com/showthread...hreadid=479214