J
Jeanette
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),""))
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),""))