COUNTIFS count if a cell has a value

[lo1ly]

Ok so I can get the COUNIFS function to count what i want it to count, but I'm trying to make the cell either leave it blank if the cell right next to it is null, or have it post the counted number if there is ANY value in the cell right next to it.. This is what I have now. I'm not sure if this will help anyone understand what I am talking about.


=COUNTIFS(Sheet1!A2:A1000,1,A2,"<>")


Any help would be awesome. Thanks everyone

 

[Marcelo Branco]

Not sure if I understand what you need.

Maybe...

=IF($A2<>"",COUNTIF(Sheet1!$A$2:$A$1000,1),"")

M.

 

[lo1ly]

Not sure if I understand what you need.

Maybe...

=IF($A2<>"",COUNTIF(Sheet1!$A$2:$A$1000,1),"")

M.

Not quite, I need the count sequence to count only if another cell has a value. For example, if the count sequence counts 80, then I want 80 to show up only if cell A1 on sheet 2 has value. If A1 on sheet 2 does not have a value, then I don’t want the count sequence to count.</SPAN>

Does that clear up any confusion?</SPAN>

 

[Marcelo Branco]

This?

=IF(Sheet2!A1<>"",COUNTIF(Sheet1!$A$2:$A$1000,1),"")

M.

 

[Marcelo Branco]

Still confused...

This?

=COUNTIFS(Sheet2!$A$2:$A$1000,"<>",Sheet1!$A$2:$A$1000,1)

M.

 

[lo1ly]

OK my bad. I made a mistake when putting it in. All your equations work. Thanks for helping out. You guys rock.