Calculations don't add up!

**gattara** · 05-09-2014, 11:40 AM

I have a spreadsheet with 80 rows and columns up to AG. The columns represent every day of the month. There is a Total column (AG) which gives the value of the total of each row, and there is a Total row (row 80) which gives the value of the total of each column. Some of the rows are sub headings, so there is no formula or value in those rows. None of the other cells hold text values. Cell AG80 holds the grand total value. If you add up all of the values in the Total column, the total you get (in AG80) should be the same as adding up all the values in row 80 – but it’s not! There is a discrepancy of 23: the total of the values in column AG is 23 less than the total of the values in row 80. I have checked all of the calculations by manually adding all of the values in each and every column, and in each and every row. Everything adds up. I have been using this spreadsheet each month for several years, and have never had this problem before. I hope someone can offer advice on how to solve this enigma - I’m at my wit’s end!

I've removed all references in the spreadsheet to my employer and have uploaded it. Thanks!

**alansidman** · 05-09-2014, 11:43 AM

Difficult to diagnose without seeing the spreadsheet itself. Are you able to upload the spreadsheet and be sure to sanitize for any sensitive/confidential information

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**RudiS** · 05-09-2014, 11:47 AM

Make a copy of the sheet and remove all the figures and retain only the AG column and 80th row formulas.
Then start putting some small values in various sections of the table and look at the totals adding.
Hope fully you will be able to pick up the discrepancy.

Another option is to use the tracer arrows in Excels auditing tools to check if all the row/column formulas are calculating the correct ranges.

**gattara** · 05-09-2014, 12:56 PM

Thanks, Rudi.

**MrShorty** · 05-09-2014, 12:58 PM

I notice that you have deleted the row sum for the greyed out rows, but row 75 has an entry for $23 in it. I don't know if the 23 is supposed to be part of the summation or not, but that is the difference.