The temperature log mixes readings and status notes. Calculate numeric readings and filled cells as separate measures.

Include zero in a sample check

Put 18 in B2, Pending in B3, leave B4 empty, and put numeric 0 in B5. Use =COUNT(B2:B5) and =COUNTA(B2:B5). Expect 2 and 3. The real zero belongs in both counts.

A reading of zero counts, Pending counts as filled, and the blank counts in neither result.

Illustrated source entries. Read the type as well as the displayed text.

Inspect what accounts for the difference

Pending is a filled text cell. In a larger log, check numbers stored as text and formulas returning an empty string, which COUNTA can count. Label the results Numeric readings and Filled fields, and keep their source ranges aligned.

COUNT returns 2 and COUNTA returns 3.

Illustrated totals. Check the difference against the source before reporting.

Microsoft’s guide to worksheet counts