formula... =sum(H3):(H17) keeps coming up with 2nd H underligned...this formula worked for column G. Can somebody help me out.
2006-12-28 09:24:36 · 6 answers · asked by 3810trebor@sbcglobal.net 2 in Computers & Internet ➔ Programming & Design
click on the cell you want to sue as the total and press the big sum button (looks like a big E) on the menu bar and it will do it automatically. You can move the dashed lines to cover all the cells you want to include
The formula is wrong it should just read sum(h3:H17), but use thhe Big E short cut
2006-12-28 09:28:06 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Try reworking the formula for that cell by typing =SUM(H3:H17).
2006-12-28 17:28:04 · answer #2 · answered by campadrenalin 4 · 1⤊ 0⤋
Try "=sum(H3:H17)" with "General" formatting.
2006-12-28 17:28:17 · answer #3 · answered by Mickey Mouse Spears 7 · 1⤊ 0⤋
I think it should actually be
=sum(h3:h17)
2006-12-28 17:27:57 · answer #4 · answered by Tish 5 · 2⤊ 0⤋
Try this:
=SUM(H3:H17)
2006-12-28 17:28:10 · answer #5 · answered by SteveN 7 · 0⤊ 0⤋
well what i think that you formatted the cells as "TEXT". change it to "GENERAL" and it might work.
2006-12-28 17:26:57 · answer #6 · answered by Faisal R 2 · 1⤊ 1⤋