Hello,

I have a question. Same situation as Jeff's but what if one of column
F (say... 761) returns a #VALUES! because it's in the form of a formula and
still waiting for a value. How will you Sumif the values?

Thanks in advance,
ampm


"Andy" wrote:

Hi

Try this:
=SUMPRODUCT(--(B2:B100=6),--(C2:C100="F"),--(F2:F100))

Andy.

"Jeff" wrote in message
...
Hello,

I need help on a Sumif Function:
I need to Sumif the values in column F if and only if column B has "6" and
column C has "F"
Here's an example:

A B C D E F
54 6 M Q SptAcc 45
75 6 M E Escada 13
1 6 F 1 MEscada 761
9 6 F E Escada 20,091
9 6 F H Accessory 335

--
Regards,
Jeff