IT Employment

Ask something
Discussion Locked

Question on using Excel

0 helpful
1 reply

by rchamber

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to create a new table in my existing spreadsheet that summarizes the data into a nice table format. The problem is that pieces of data are approx. 20 rows apart. I have tried "=sum (j23)" type formulas but Excel picks up the next roll not the 20th row.

HELP!

1 reply

by harv11

Your formula needs to reference the specific cells where your data is located. ex: =sum(j23+j45) This will add the values from each cell to form a total in the cell where you type the formula.

This discussion is closed to new replies.