Attached is a sample of a file I am having an issue with, namely the Sum by Year section on the Jobs by Type sheet. Fir some reason I can't get the formula to work when changing years. The sum by Customer section works fine but everything stops when trying to sum by year. I have looked a formats and I think they are fine (they do work when sunning by customer). Any help would be appreciated.
Jim O
Bookmarks