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.

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.

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



