I am trying to find a formula that will add the SUM of the rows. I've tried SUM(A4:A30) but that didnt work. Can someone help me?
2007-10-16 06:43:14 · 8 answers · asked by instilleddistress 3 in Computers & Internet ➔ Software
=SUM(A4:A30)
You forgot the = sign.
2007-10-16 06:45:49 · answer #1 · answered by I love my baby boy! 5 · 1⤊ 0⤋
If you want to get the sum of all numerical values in cells A4 to A30, you type:
=SUM(A4:A30)
You need the = sign in there. In order to find the sum of all numerical values in a single column, you can type it like this:
=SUM(A:A)
That looks at the entire column rather than just some of the cells in the column.
2007-10-16 06:47:52 · answer #2 · answered by Anonymous · 1⤊ 0⤋
You have to put an equal sign in front of the formula
=SUM(A4:A30)
All equations have to start with an "=", or they are treated as "text" instead.
2007-10-16 06:47:35 · answer #3 · answered by dewcoons 7 · 1⤊ 0⤋
For Rows
=sum(Row:Row)
For Column
=sum(COLUMN:COLUMN)
2007-10-16 06:48:02 · answer #4 · answered by Anonymous · 1⤊ 0⤋
Just "drag" the rows. No need for a formula.
2016-05-22 23:12:51 · answer #5 · answered by ? 3 · 0⤊ 0⤋
I highlight the rows I want added and then click the sum icon at the top.
2007-10-16 06:47:04 · answer #6 · answered by wendy_da_goodlil_witch 7 · 0⤊ 2⤋
You can of course scroll across the rows (leaving a blank cell on the right) and click the Sigma toolbar?
2007-10-16 06:48:31 · answer #7 · answered by Eddie D 6 · 0⤊ 1⤋
Yep you must start all equations with an =
Robin was right.
2007-10-16 06:47:18 · answer #8 · answered by Crazy Diamond 6 · 1⤊ 1⤋
u want the WHOLE column?
does =SUM(A:A) work?
2007-10-16 06:47:04 · answer #9 · answered by kleptomanic sheep 5 · 0⤊ 1⤋