two if conditions, then a counta formula issue

  • Thread starter Thread starter Jeanette
  • Start date Start date
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),""))
 
Try
=IF(AND(Sheet1!$A$3:$A200=70,Sheet1!$B$3:$B200="OCT"),COUNTA(Sheet1!C3:C200),"")
 
Hi,
could you post an example, range A3 to A1000 the hole range has to be 70 to
count C, or you want to count only the rows that are not empty and meet both
conditions if the last assumption is true use

=COUNTIFS(A3:A1000,70,B3:B1000,"Oct",C3:C1000,"<>")
 
I'm not sure I followed you - but could'd this be the answer to your question:
=SUMPRODUCT(($A$3:$A1000=70)*($B$3:$B1000="OCT"))
Micky
 
Back
Top