Ignoring Cells with Only Spaces
 

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy

Ignoring Cells with Only Spaces
 

=COUNTIF(A1:A100,"* ")


"Heliocracy" wrote:

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy

Ignoring Cells with Only Spaces
 

That appears to do the opposite of what I'm asking.

If cell A1=" ", COUNTIF(A1,"* ") returns a 1. I need a formula to return a
zero if there are only spaces in cell A1.

Thanks.

"Heliocracy" wrote:

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy

Ignoring Cells with Only Spaces
 

Try something like this:

=SUMPRODUCT(--(LEN(TRIM(A1:A10))<0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Heliocracy" wrote:

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy

Ignoring Cells with Only Spaces
 

Yes, that does appear to do it. Thanks.

"Ron Coderre" wrote:

Try something like this:

=SUMPRODUCT(--(LEN(TRIM(A1:A10))<0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Heliocracy" wrote:

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy

Ignoring Cells with Only Spaces
 

I'm glad that worked for you....and thanks for the feedback.

***********
Regards,
Ron

XL2002, WinXP


"Heliocracy" wrote:

Yes, that does appear to do it. Thanks.

"Ron Coderre" wrote:

Try something like this:

=SUMPRODUCT(--(LEN(TRIM(A1:A10))<0))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Heliocracy" wrote:

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy