two if conditions, then a counta formula issue

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

Ron@Buy

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

Eduardo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top