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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Count Number of Unique Cells That Don't Have Certain Characters 0
Section and Page numbering 0
Is there a function to count how many times a cells value is used? 0
Countif or other formula needed for multiple data/critera results 3
Counting the Number of times the Slides are visited 0
Count Non-Empty Cells In Each Row 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Top