COUNTA and "" not working together

[lordfa9]

lets say I have this formula

IF(A1>0,"","Negative")
Repeated downwards from B1 to B100

Then I use a COUNTA function:
COUNTA(B1:B100)

I noticed that it will count cells that are otherwise supposed to be blank.

I do have a workaround using total number of cells minus the output from a COUNTBLANK formula [100-COUNTBLANK(B1:B100)] but just curious to know why COUNTA isn't working.

[MarvinP]

Hi lordfa9,

Read the first Remark point on https://support.office.com/en-us/art...rs=en-US&ad=US

CountA counts "" but does not count blank cells.

Is that what you are finding is true?

[ELeGault]

Exactly - You want a CountIFS.

Count if cells are NOT blank

Please Login or Register  to view this content.

Count if Cells ARE Blank

Please Login or Register  to view this content.

Now if you keep your helper columns, you can count if they are "" and Not ""
Count of Blanks or "" in your given range

Please Login or Register  to view this content.

Count of Negatives in your given range

Please Login or Register  to view this content.

[lordfa9]

Hi lordfa9,

Read the first Remark point on https://support.office.com/en-us/art...rs=en-US&ad=US

CountA counts "" but does not count blank cells.

Is that what you are finding is true?

sadly yes

I'll try elegaut's ideas on Monday when I'm back at work