Came up with a solution through T/E. It was simply =SUM( with seven embedded IFs, one each for the five headers and one each for the start and end dates.
Came up with a solution through T/E. It was simply =SUM( with seven embedded IFs, one each for the five headers and one each for the start and end dates.
Last edited by roothog; 10-02-2015 at 09:03 PM. Reason: mis-aligned columns
could you put it together in a workbook and send it to the forum?
I should've done that first. Thanks.
File with better explanation.
roothog
Came up with a solution through T/E. It was simply =SUM( with seven embedded IFs, one each for the five headers and one each for the start and end dates.
Put in B13
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks