S sarah Jan 27, 2004 #1 how can I write a formula that counts the number of cells that contain numbers and then add up those numbers
how can I write a formula that counts the number of cells that contain numbers and then add up those numbers
B Bob Phillips Jan 27, 2004 #2 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)
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)
