SUM not working correctly

Question

Level 1

8 points

SUM not working correctly

I am having a frustrating issue with the SUM key not adding my numbers correctly (or at all).

I double tapped the cell below the numbers I wish to add and went to = and then hit the sum key. The formula is SUM C2:C19 but it's only inputting the C2 number in the SUM cell.

I could go through one by one and add up each cell manually in the formula but it would be much easier to use the SUM key if I can. I'm just wondering why it's not working like I think it should. Any help would be appreciated. Thanks!

iPad (3rd gen) Wi-Fi + Cellular (VZ), iOS 5.1.1, 64GB Black

Posted on Jun 26, 2012 9:26 AM

Reply

Answer 1

jaxjason

Level 5

5,063 points

Jun 29, 2012 6:55 AM in response to candafilm

This usually has something to do with formatting. Are the cells C3:C19 formatted as text by chance? Or some other format that wont be recognized by the SUM function?

Thanks

Jason

Reply

Answer 2

KEANDAU

Level 1

28 points

Jun 29, 2012 11:51 AM in response to candafilm

Also, Did you try to ( ) around the cells - SUM(C2:C19). I had a similiar issue recently and this worked.

Kevin

Reply

Answer 3

Jul 16, 2012 8:49 PM in response to KEANDAU

Just highlight where the range in your formula should be then highlight the cell range in the table by tapping on c2 and dragging the handle of the selection to c19.

Reply

Answer 4

candafilm Author

Level 1

8 points

Jul 16, 2012 9:05 PM in response to candafilm

They were formatted as text, felt pretty dumb after I checked, lol. Thanks!

Reply

Answer 5

Jul 16, 2012 9:24 PM in response to candafilm

I was going to ask that. The formatting got me good when I tried averaging a selection. Stumped me good.

Reply