Combination Lookup: Column 1 (Employee Name) + Column 2 (Code) + Row (Month) and sum

[wherdzik]

I think this is possible. I need a lookup that combines 2 columns and row and sums up together.

Attached are 2 sheets:

1. Live Cube - This I will be refreshing each month from a OLAP cube. I will be adding a new month. It contains the name of an employee, the code they bill, and respective month.

2. Summary Sheet - This will lookup the Live Cube for the name, the code and month name and sum up all the code quantities together. The code names can repeat so they have to be summed up together.

I hope I was successful in explaining that. I have added a file for example.

Thank you for taking the time out of your day to help.

[Bo_Ry]

Please try at C3

=SUMIFS('Live Cube'!$D$3:$D$222,'Live Cube'!$C$3:$C$222,$B3,'Live Cube'!$A$3:$A$222,C$2)

[wherdzik]

I think the formula is not taking in consideration of the employee name. This sample of data only includes one person but If in the live data it will have multiple employees. So it needs to consider the employee as well. Can the formula be augmented?

[wherdzik]

I apologize for sending so early, I have figured it out. Thank you for your help