how do I sum a column of cells that also contain text? I just want excel to ignore the text, or sum all the numbers into a /gallons per year.
2007-09-12 09:17:03 · 5 answers · asked by subhuman 2 in Computers & Internet ➔ Software
You don't have to do anything special.
Excel doesn't treat text like it does numbers. (At least not in 2000, which I tested my answer in.)
If you have a column with some cells having numbers, other cells with text and some with nothing in them you can simply include the whole range in your formula.
This also works with AVERAGE and COUNT
2007-09-12 15:31:35 · answer #1 · answered by Will See 3 · 0⤊ 0⤋
Is the text in different cells than the numbers? If so, just a =sum(whatever:whatever) should work. Also, you can sort the column in ascending order, and just delete out the text.
2007-09-12 09:42:09 · answer #2 · answered by Russ B 2 · 0⤊ 0⤋
It's easy.
Just click the summation button or type in:
=SUM(
Then select your range. Then make sure the formula ends with a ending parenthesis.
Excel will disregard the cells with text and just add the cells with numbers. I tested it just to make sure it works and it does. So there's no special summation formula you have to use.
2007-09-13 05:41:47 · answer #3 · answered by devilishblueyes 7 · 0⤊ 0⤋
=sum(range)/appopriate factor to provide gallons
Appropriate factors might be
Ounces = 16
ml = ((ml*specific gravity) / 28.35)/16
God Bless
Frank Pytel
2007-09-13 10:34:40 · answer #4 · answered by Frank Pytel 4 · 0⤊ 0⤋
SUMIF
2007-09-12 09:22:49 · answer #5 · answered by pricehillsaint 5 · 0⤊ 0⤋