Need help with IF Formula
Try this:
=SUMPRODUCT((B$1:B$20="Apple")*(A$1:A$20="F"))
You could put Apple and F into some other cells, and then refer to
those cells in the formula rather than the specific values.
Hope this helps.
Pete
On Jun 17, 4:11*pm, Fgbdrum wrote:
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.
|