Hi all,
I've got a series of SUMIFS running on a sheet, giving totals for various elements of a business. However they seem to have stopped working... I've not knowingly altered the formulae. They give some results, but it doesn't seem to count all of the data, meaning that my income total varies by around £30,000. Temporarily, I've got the range set from *column*2:*column*10000, and the data hardly covers 500 cells!
Weekly figures for (contained on the "stats" sheet):
Weekly Exclusive rafts (Column C)
Weekly Individual Rafts (Column D)
Weekly Income (Column G)
Monthly Exclusive Rafts (Column M)
Monthly Individual Rafts (Column N)
currently do not work. There's various other formulae that rely on these cells, so there's a domino effect going on.
Any corrections/advice always welcomed!
Workbook attached
WWM
Bookmarks