Count number of items in Col A from Row 2 , excluding "Grand Total" and Blank cells

[Howardc1001]

I am trying to count the number of items in Col A , excluding text "grand Total" and excluding i.e ignoring blank cells

Please Login or Register  to view this content.

It would be appreciated if someone would kindly amend my formula

[Kaper]

If blanks are "real blanks" (empty cells) then:

Please Login or Register  to view this content.

shall do

[Kaper]

PS. this condition
A:A;"<>"" "
excludes cells with one double quotation and space, so:
"_
(underscore used instead of single space), or visualized between | characters:
|" |

[Howardc1001]

Thanks for the help Kaper