I have been fumbling with this one for awhile and I think it is time to reach out!
I have three columns and I would like to total the HOURS column for each individual listed in the NAME column, based on a date range (ie. between Apr 1 to Apr 6).
NAME HRS DATE
Bob 2 2-Apr-13
Bob 1 4-Apr-13
Sam 2 2-Apr-13
Bob 4 8-Apr-13
I have tried SUMIFS and SUMPRODUCT, but I'm falling short. The date range is particularly challenging. Is this doable?
Thanks!
Bookmarks