What is going on here.. why is this giving a result of 1323.92 when its 1094.92 when added up?
There's nothing in the blank spaces i clicked them all and deleted to be sure. idk whats going on.
There's nothing in the blank spaces i clicked them all and deleted to be sure. idk whats going on.
| Book4 | ||||||
|---|---|---|---|---|---|---|
| C | D | E | F | |||
| 1 | Qty | Cost | Total Amount | |||
| 2 | 1 | $129.99 | $129.99 | |||
| 3 | ||||||
| 4 | ||||||
| 5 | 1 | $219.99 | $219.99 | |||
| 6 | ||||||
| 7 | ||||||
| 8 | 1 | $529.99 | $529.99 | |||
| 9 | ||||||
| 10 | ||||||
| 11 | 1 | $19.99 | $19.99 | |||
| 12 | ||||||
| 13 | ||||||
| 14 | 1 | $44.99 | $44.99 | |||
| 15 | ||||||
| 16 | ||||||
| 17 | 1 | $229.00 | $229.00 | |||
| 18 | ||||||
| 19 | ||||||
| 20 | 1 | $44.99 | $44.99 | |||
| 21 | ||||||
| 22 | ||||||
| 23 | 1 | $59.99 | $59.99 | |||
| 24 | ||||||
| 25 | ||||||
| 26 | 1 | $44.99 | $44.99 | |||
| 27 | ||||||
| 28 | ||||||
| 29 | $1,323.92 | $1,323.92 | ||||
Sheet2 | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| E29 | E29 | =SUM(E2:E27) |
| F29 | F29 | =E2+E5+E8+E11+E14+E17+E20+E23+E26 |
