Excel Sumif Counting Text

Question

I am trying to count the number of cells that contain text (that are not empty).

I'd like to make a SUMIF (or I can use another function if a different one works better) that will count them for me and generate a number based on my cells containing text.

See Below:

Peaches	Apples		2
Bananas			1
Grapefruit	Pears	Oranges	3

The column furthest to the right is where I want excel to do the SUMIF to count the number of cells (in the specified range) which aren't blank.

I tried to use the wildcard * but it always returned "0" as my sum when I had text in the specified fields.

Answer 1

Hi Rachel,

The COUNTA() function returns the number of cells in it's parameter range that are not blank. Note that values of "" or an empty string or a formula that returns an empty string do count towards the total returned by COUNTA().

Effectively, an empty cell is one that has no formula or value in it. A cell that is filled with a blank is still filled. 

Please let me know if this helps or if you need further assistance.

Thanks,

EBW

Answer 2

Thanks for the response! I tried it and we're close, but not quite there yet.

It is generating what is essential my desired value plus 1. So, if I want it to read "3" for three non-empty cells, it is giving me 4.

Tips?

Answer 3

hi 

try this 

=COUNTIF(A1:C1,"*")

regards

Answer 4

Hi, try

=COUNTA(A1:C1)

copy formula down