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

two if conditions, then a counta formula issue
 

Try:
=IF(AND(Sheet1!$A$3:$A200=70,Sheet1!$B$3:$B200="OC T"),COUNTA(Sheet1!C3:C200),"")

"Jeanette" wrote:

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

two if conditions, then a counta formula issue
 

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

"Jeanette" wrote:

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

two if conditions, then a counta formula issue
 

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


"Jeanette" wrote:

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