need help on Sumif with index and match multiple criteria

Hi All,

I am not an excel expert but trying my hands on creating a report with tiny bit of knowledge which i have on excel. please help me in the below.

I am trying to create a report where is have source data from which i need to sum up the total time in Source tab depending on different criteria like

1.I need to get the sum of all users based on the date range if i select week 16 all the users along with different criteria should sum up the details with that dates.
2. I have different activity in source data and each user has most of the activities, i need to sum up different activities for each user and give me the total of time.

Please tell me the best way to do this as i am stuck. i was trying to use Index and match formula with sumif function.
Is that the best option and if yes please tell me how do i do this.

Attached is the sample file your reference.

Thanks
Muheeb

Example for user code Mave for column K in week tab it has to look for Inv F and J in source tab and look for Mave in user and check for the date range and give the sum of time which comes upto 7.90 for week 1.

hope this helps.

This is only for F but i have more options in there say around 5 options what do i do for that.

Originally Posted by :) Sixthsense :)

In K16 Cell

Formula:

Please Login or Register  to view this content.

Drag it down...

There is some extra spaces in the end of USER NAMES in Source Sheet Column H data. If you remove those spaces from that column then you can simply use the formula without Wild Card Character like this...

Formula:

Please Login or Register  to view this content.

Like you have used F in your formula i have J i have N and so on how do i get them in the same formula

Thanks, but then where is the date range in this i need to select say for week 2 i have to select the data between dates 7th Jan to 11th Jan.
Your formula is taking the sum for the entire month which is not what i need.

Sorry, but that was my first point in my question, guess it missed your attention.

Originally Posted by :) Sixthsense :)

Please don't add the conditions one by one, INSTEAD post all your requirement in a single post. Sorry I am not interested to continue with this thread.

Thanks Buddy,

Will make sure next time i highlight what i need so that i can avoid the trouble.
Can i give a cell number instead of entering the date in the formula ?