Use the SUMPRODUCT function:

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

change the D1:D100 to the range containing the values you want to
sum.


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




"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