Geek asks and answers

Only count fields with text / data, not formulas

I have a listing of the headcount for this month, which I compare with the budget. I used vlookup to match the actual budget. Then: = IF (ISNA (M66), K66, "") to return names that are not in the budget but in action (HR file) or empty.

Now I would like to count the names returned in the column, but I am having problems with the count functions that recognize the formula in the cells, even if they are empty.

Thank you for your time!

+7
source share
3 answers

[Edit - did not notice a space in "" - delete this as Scott suggests, then try below]

A2: A100, , "

=COUNTIF(A2:A100,"?*")

=SUMPRODUCT((A2:A100<>"")+0)

+11
COUNTA(A2:A100,"")-COUNTA(A2:A100)
+1

I have similar questions, I have many cells for inventory, and I want to add all the numbers in the cells for monitors, computers, etc. ...... I do not need to count how many cells, but in total all the numbers in certain cells

BUT

the problem is that I have text in these cells also ..... 12 monitors 4 computers, etc ...

How would I go about this?

0
source

More articles:


All Articles