Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |