Count and Sum

S

sarah

how can I write a formula that counts the number of cells
that contain numbers and then add up those numbers
 
B

Bob Phillips

Sarah,

If you sum a range, it ignores text. =COUNT(A1:A100) counts the numeric
values in a range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top