OK Excel gurus! For the life in me I cannot figure this out. I am going to try to paste the cells from a grid in below. Across the top under each month are the results of the formula applied to each month. On the right, I ad the results of each month and get $28,396.73. However, when I do the same formula on the totals of each row (i.e. the whole year) I get $28,428.36. That seems like a lot of variance for a rounding error! I would expect these two values to be exactly the same. Any ideas why not?
If you paste the below into Excel the formula in cell B2 (which is $829.34) is =((B4+B5)*((B6+B7)/B8))+B6+B7+B9+B10+B11
I would expect that the same formula applied to the yearly total would be equal to the sum of each monthly total but it is not.
Screenshot for clarity:
| Jan | Feb | Mar | April | May | June | July | August | September | October | November | December | | | |
|-----|------------|------------|------------|------------|------------|------------|------------|------------|------------|------------|------------|------------|--------------|-----------|
| | 829.34 | 735.75 | 1,521.44 | 1,556.90 | 2,690.49 | 2,767.04 | 2,905.11 | 3,157.43 | 3,132.17 | 3,147.30 | 3,116.02 | 2,837.75 | 28,396.73 | 28,428.36 |
| | | | | | | | | | | | | | | |
| A | 9,587.89 | -2,711.10 | 18,637.86 | 26,467.32 | -6,264.93 | 4,433.74 | 26,573.66 | 18,278.19 | 19,856.50 | 20,837.80 | 19,929.65 | 19,929.65 | 175,556.23 | |
| B | 14,548.92 | 12,176.03 | 11,772.03 | 11,069.96 | 14,242.51 | 15,850.23 | 15,520.98 | 18,429.26 | 15,799.47 | 16,148.24 | 15,708.04 | 11,707.63 | 172,973.30 | |
| C | 570.1757 | 570.1757 | 570.1757 | 570.1757 | 643.1117 | 643.1117 | 643.1117 | 643.1117 | 643.1117 | 643.1117 | 643.1117 | 643.1117 | 7,425.60 | |
| D | 122.1278 | 122.1278 | 122.1278 | 122.1278 | 673.0078 | 673.0078 | 673.0078 | 673.0078 | 673.0078 | 673.0078 | 673.0078 | 673.0078 | 5,872.57 | |
| E | 150,833.34 | 150,833.34 | 153,858.56 | 150,833.33 | 180,259.90 | 198,041.65 | 203,028.58 | 233,580.13 | 258,458.31 | 247,471.73 | 283,542.33 | 283,113.12 | 2,493,854.32 | |
| F | | 26.25 | 570.1757 | 570.1757 | 643.1117 | 643.1117 | 643.1117 | 673.5 | 673.5 | 673.5 | 673.5017 | 643.1117 | 6,433.05 | |
| G | | | 122.1278 | 122.1278 | 673.0078 | 673.0078 | 673.0078 | 902.54 | 902.54 | 902.54 | 902.5411 | 673.0078 | 6,546.45 | |
| H | | | | | | | | 58.44 | 58.44 | 58.44 | 58.44 | 58.44 | 292.2 | |
code-sample
to the pasted data. Makes it much easier to copy/paste into a worksheet for testing purposes.