Share via

Excel 2016 sum function not adding up

Anonymous
2017-12-15T14:14:11+00:00

Hi, when I select a few cells to add up in excel (ex. =sum(C20,C30,C40) I get a zero answer. I have tried formatting the cells as numbers and currencies, my calculator is set to automatic.  The cells I select to add up are also pre-existing formulas (ex C20 will be =sum(C10:C19)

Please advise.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2017-12-15T14:19:27+00:00

    This can only happen if values in C20, C30 and C40 are not numbers.

    Do following -

    1. Copy and paste the formulas in Notepad
    2. Delete the existing formulas in these cells by pressing Delete button
    3. Right click on these cells > Format Cells > General
    4. Copy back the formulas

    Now, you should get the right result.

    Was this answer helpful?

    0 comments