I need to create a formula that counts the number of jobs matching specific criteria (e.g. overdue, due this week, due this month), over three sheets in the same file; AND displays the count in a cell- which I can then double click to bring up a table of those jobs (similar to pivot tables).
I need to be able to save this formula in a template as the source data will change every week and I don't want to have to go through the bother of tweaking pivot tables every time.
I've had no luck with countifs and sumproduct, as i cant seem to combine the three source data, and getting the cell "double click"option to bring up a table either.
Solved by V. S. in 19 mins