Thread: If Statement with Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Crazyhorse
 
Posts: n/a
Default If Statement with Countif
A B C
1 Y Y
2 Y N
3 N
4 N Y
5 Y Y
6
7 Y Y

If there is a "Y" in Columns B and C then Count the "Y"

The Answer will be 3.

Thank you
Reply With QuoteReply With Quote