How can I get totals for multiple criteria?

[mcoleman76]

Please see the attached spreadsheet for reference.

I want to have a summary of each staff member and the total hours they are working for that week under the various different projects.

Is there any way to do this? Thank you in advance for yourh help

[TMS]

The question would be something like: how can I get totals for multiple criteria?

And the answer would be something like: have a look at SUMIFS.

[dilipandey]

Hi mcoleman,

Welcome to the forum.

Suggest you to change the title of the post to something relevant i.e. "How to total working hours per week" etc and post a sample excel workbook not the image. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[TMS]

N41: =SUMIF($C$7:$C$25,"=Staff " &ROWS($A$41:$A41),N$7:N$25)

Copy across and down.


Regards, TMS