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

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

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