View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fgbdrum Fgbdrum is offline
external usenet poster
 
Posts: 18
Default Need help with IF Formula

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.