Sum number range ignoring numbers formatted as text

Jul 1, 2015
Reaction score
I need help summing up numbers in a row that are formatted as numbers, text, and blank cells. For example, A1:A20 will have numbers formatted as text and will also have numbers formatted as numbers.
A1 12:30
A2 2:30
A3 2.00
A4 8:00
A5 10:00
A6 2:00
When I sum these, the answer should be 4 (A3 and A6), instead whole bunch of formulas will add up all of the numbers. Have tried =sum(A1:A20), =sumif(A1:A20, range), =sum(sumif(A1:A20,{">0","<0"})) Please help.

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