Can you add the contents of an entire column in Microsoft Excel?

Question

My teacher provided us with excel documents that have info for a project for class. It is for an advertising class, each row represents a different ad in a magazine. The columns contain different info about the ad, with the last column containing all the different amounts of money spent placing the ad. I want to add up all the numbers in the money column (there are about 900 of them). Is there a way to do that with excel or should I just forget about it?

Answer 1

to add an entire column together go to any box and enter the formula (=sum xy:xz) where x = the column letter (IE A,B,C) and y= the start row and z= the end row. as for moving entire rows clicking on the row number far left which will highlight it all and using cut paste is probably the easiest. Above is also correct with the hide feature.

Answer 2

As long as there are numerals, you can add the column. Put your cursor in the space where you want to see your sum and then click on the fx next to the address bar above the worksheet. Choose sum and follow the directions to have it do the addition for you.



Instead for deleting rows or columns, it may have been wiser to hide them. Highlight the rows you want to hide and then click on Format, then choose either row or column, and then Hide. You can always Unhide them later by following the same steps, but they're out of the way while you're doing your work and you won't have to do so much scrolling.



Hope that helps...



Saw your question about Format. You can format the numbers in a cell to monetary values, scientific, accounting, general, etc. With your cursor in a cell, click on Format at the top, then cell. You'll see several tabs there and you can play with each of them to set up your worksheet. The one entitled Number is where you will choose Currency and then look to the right to choose decimal placement, currency symbol and how to show negative values.



Hang in there...you'll catch on!

Answer 3

Assuming that all rows in the column you want to add are numeric, just click on the box you want to place your sum in under the final number in that row, click on the "autosum" button, and hit enter. That'll put the sum in that box for you. It's that simple.



Also, if you want to "hide" some of the rows so you don't always have to scroll down to the last row you are placing this box in, just select the rows you want to hide, then on the Format menu, point to Row, and then click Hide. Your rows will be out of site. You can make them reappear by selected the row above and below the ones you have hidden, then click on Row and click on Unhide. They'll all return to view for you.



Good luck.

Answer 4

To total the row =sum in the blank cell under the column

To delete a row or even a column-highlight and then hit the delete button.

To move a column up or down-highlight it and then go to the bottom right hand side of the last cell and drag (to move row down) to move row up-highlight the top cell and click on top right hand side of the cell and move up.

You can also hide columns without deleting them by highlighting the entire column-right click and click on hide-just do the reverse to unhide it.

Answer 5

to total the amounts go into an emply cell beneath them. In that cell enter =SUM(click and drag all the cells you want to add together) Your cell should read:



=SUM(B1:B230)



Make sure to format the cell to a currency setting



To delete rows, highlight the rows you want to get rid of and click "delete". If you highlight the rows and choose delete from the toolbar (under Edit) it will shift your rows up. That way if you have anything under the highlighted areas, you don't lose it and it all stays together (you don't have to scroll down to find it). Good luck!

Answer 6

Do you not know how to use Excel at all? You can highlight the row of data that you want to add and look at the bottom right of your screen and see the total. That's one way to get the total. To delete a row, right click and select delete.



By the way, when you delete the data, you obviously are not including those delete rows in your totals. Instead of deleting the rows that you don't want to see, but need in your totals, why not just hide it? Again, right click and select hide. You need to take some type of Office class.