I am trying to figure out why my SUMIFS formula is not working at the attached sheet? Does it have an issue with Date values? If this is not the best approach any other suggestion to get the sum of hrs per person per week?
RB
I am trying to figure out why my SUMIFS formula is not working at the attached sheet? Does it have an issue with Date values? If this is not the best approach any other suggestion to get the sum of hrs per person per week?
RB
Last edited by we4brans; 02-06-2020 at 03:29 PM.
Change the formula in C3 to this:
=SUMIFS(Sheet2!B$2:B$59,Sheet2!$A$2:$A$59,$A3)
then you can copy across and down as required. You don't need to try to match on dates, as your columns in both sheets are contiguous, so as you copy across the first term will automatically adjust to suit the column it is in.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks