Hi, hope someone can help me with this one.
I have added an attachment here with my spreadsheet tracker for a large multi site project, which I've butchered a bit for simplicity and confidentiality reasons, only keeping in the important bits.
The main sheet tracks all the relevant details of each site, dates, costs, quotes etc.
The second sheet is a summary page which should automatically update as new entries are made on the main sheet. All is working ok, but when I checked some of the calculations on the summary sheet there was a difference in the Total figures. The calcuations are made in columns, but in checking the rows they dont hac=ve that same result
I am certain that rows 4 - 8 are all correct, with correct results in F4 down to F8.
The figures in range C14 to F16 are the concern, particularly the Totals cells -F14, F15 and F16. Column-wise they all add up correctly, but when doing a check and adding up the rows (ie C14, C15 and C16) they should be the same result but they are not.
I have highlighted the cells in yellow and added in the alternate results in column G as a visual aid.
F16 and G16 should both have the same figure (as should F15/G15 and F14/G15).
I've looked at these several times and i cant see where the problem is, so I hope someone can point me in the right direction.
Thanks
Steve
Bookmarks