adding columns and rows of figures on excel and clicking sum only getting last figure what am i missing?

Question

thanks for that yhe tax man will be pleased will now finish tonight!!

Answer 1

You've probably got a blank cell directly above the last one (excel adds up cells that have data in them and so stops when the data stops).

Click sum and highlight with your mouse the range of data that you want to add up then hit return.

Answer 2

No i don't... yet purely as others don't have a say in how I enhance my young ones, I don't have a say in how others enhance their young ones. i'm against indoctrination yet i can not see a thank you to combat it with out removing the freedoms of others. I advise what if somebody advised you it became into incorrect to enable your infants play with Ninja turtles action figures because of the fact it advocates vigilantism? So on an identical time as my own opinion is that teachings interior the bible directed in the direction of youthful infants that glorify the violence and genocide in the bible utilising action figures are certainly incorrect.. i can not forget approximately that human beings might think of an identical approximately many different action figures and the ideals they characterize. as quickly as you start up there it won't supply up at that, exceedingly quickly any violent action figures would be banned.. as an occasion i think of Bratz dolls tutor ladies to be self-based and shallow, yet is it my place to tell human beings they are in a position to't purchase them for their infants? No it is not. i would not choose somebody else telling me what my young ones can play with this is suitable, so I won't do it to human beings.

Answer 3

You need to hightlight all the boxes containing data you want to add up.

Answer 4

are all rows and columns contents properly selected? you can tell coz they are highlighted

Answer 5

select the cell where you want the sum.
write '=sum(first_cell:last_cell)'
into the cell.
The sum will appear in your selected cell.

Answer 6

You did not specify the "range".