SUM IF with multiple parameters

[olimajor123]

Hi there,

Looking for a SUMIF for the follow.

Have a table with several columns that I want to display data from in another table. I need a cell to display the total value for labour for a certain person for a certain period. Column B in the master table has the period in, column M has the category (of which I need labour), Column E has the employees name and column I has the figures in. I want to display the total for a certain period if the column M category is 'Labour' and the column E is a certain employees name. Ie I want the total for all the labour for david in period 1.

I think there is probably a way to do this via V look up but I would rather do a sumif so it automatically updates each period.

Please can you help.

Thanks

 

[Aladin Akyurek]

Looks like...

=SUMIFS(I:I,B:B,"period 1",E:E,"david",M:M,"labour")

 

[Oeldere]

Reading your question, I think I solved this with an pivot table.

other solution with sumproduct

=sumproduct($M1:$M1500="Labour")*($E1:$E1500="the employee name")*($B1:$B1500=1)*($I1:$I1500))

 

[olimajor123]

Thanks guys