Need help with IF Formula
Try this:
=Sumproduct((a1:a100="F")*(B1:B100="Apple"))
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Fgbdrum" wrote in message
...
Hi-
In principal, I'd like to do a COUNTIF statement within an IF statement.
Can't seem to get it to work just right. Here's my sheet:
Column A Column B
A APPLE
B ORANGE
F APPLE
I'd like the formula to say:
If column B equals APPLE, count column A if it equals F.
This would give me a return of 1.
Would appreciate any help on this. Thank you.
|