Sumif Function
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
|