Thread: two if conditions, then a counta formula issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeanette Jeanette is offline
external usenet poster
  
Posts: 24
Default two if conditions, then a counta formula issue
I need the formula which will do the following: If sheet1A3:A1000=70 and if
sheet1B3:B1000="OCT, then COUNTA(sheet1C3:C1000), it worked once and can't
get it to work again.

=IF('sheet1'!$A$3:$A200=70,IF('sheet1'!$B$3:$B200= "OCT",COUNTA('sheet1'!C3:C200),""))
Reply With QuoteReply With Quote