COUNTA, remove null or blanks from count

[JR2]

I'm using the following formula, but I do not want it to take into account blank cells or null cells.
=COUNTA(Monday!L5:L11,Tuesday!L5:L11,Wednesday!L5:L11,Thursday!L5:L11,Friday!L5:L11,Saturday!L5:L11,Sunday!L5:L11)


The above cells also have the following formula
=IF(COUNTIF(B6:K6,"X")=0,"",COUNTIF(B6:K6,"X"))

 

[dreid1011]

COUNTA counts non empty cells, and formulas in a cell count as "non empty", even if they are returning a "". You may likely need to use another COUNTIF/COUNTIFS for cells that are not blank. What values are in those cells anyway?

 

[Fluff]

Hi & welcome to MrExcel.
Change the COUNTA to COUNT

 

[Joe4]

Welcome to the Board!

If you use COUNT instead of COUNTA, it will only count the cells containing numbers!

 

[Joe4]

What values are in those cells anyway?

From the original post:

The above cells also have the following formula
=IF(COUNTIF(B6:K6,"X")=0,"",COUNTIF(B6:K6,"X"))

So, the only possible values that formula can return is "" or numbers greater than 0.

 

[dreid1011]

From the original post:

So, the only possible values that formula can return is "" or numbers greater than 0.

It would seem the most sense is made when I read all of the post. Rather, I read it, but didn't stop to consider what the formula was returning. Oops.

 

[Joe4]

It would seem the most sense is made when I read all of the post. Rather, I read it, but didn't stop to consider what the formula was returning. Oops.

No worries!
I was just about to ask the same question myself, but then I went back and read the original post a little closer and figured out what it was returning.

 

[JR2]

Thanks everyone, changing it to COUNT solved it. I also appreciate the "TIPS FOR FINDING EXCEL SOLUTIONS". I need to get better on how to write my question, to search for a solution before posting.

 

[Fluff]

Glad we could help & thanks for the feedback.