sumproduct Or sumifs on multiple criteria matching day & time
has to sum all data given in each single date, by matching by date & time from another sheet which has data in same pattern of time but instead of date it has day in the rows. each date will have a cumulative sum matching time & day & multiply by duration then divide by 30.
kindly fund attached file to see a desired result calculated, see if the desired result can be generated by single formula.
Please help me ,, i
Maybe this:
This might work as well.
Last edited by pepe74287; 03-16-2015 at 04:30 AM.
I came up with this:
Formula:
Please Login or Register to view this content.
BUT
I had an issue with 16:00 hours. MATCH (or LOOKUP) couldn't find it, yet the simple test of = shows that the two cells showing 16:00 are equal. How on earth is that possible??? When copying one 16:00 over to the other it worked. Mystery sheet included in my workbook.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Sorry, didn't realized where the formula should be placed.
Yes, there is problem with 16:00 format in original sheet.Originally Posted by Jacc
Just re-enter it.
pepe or zbor, could you please take a look at my mystery sheet before my head explodes? Sorry for sidetracking your thread tabkaz but your time values are a bit strange, they refuse to match.
Didn't see your post until now, thanks for the feedback zbor! Although I was hoping for an explanation as well.
thanks everyone really appreciates for ur quick replies... has used Jacc solution as it was comparatively easy to adapt, thanks again for being so supportive buddies
''''''''
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks