Formula to Track Consultant Hours per Month

Michele Phillips

Hello,

I have a sheet used to enter consultant time and I'm trying to develop a metric to track the info. I''m struggling with a formula that will add the hours for a specific individual per month. Here is a snippet of the sheet:

My metric looks like the snippet below:

My formula is not working: =SUMIFS({Staffing Calendar Range 3}, {Staffing Calendar Range 8}, =Bill M}, =Primary1)

I have this formula references two different ranges - Range 3 is the Hour column on the sheet, and Range 8 is the Assigned column. The Month column on the sheet picks up the Date in the far left column of the sheet.. I've tried adding another range for the Month, but I think what I need is to tell Range 3 what to add - for instance =hours@row whatever. Nothing I've tried works. Any help will be greatly appreciated. Thank you!

Paul Newcome

You are going to want to use something along the lines of...

=SUMIFS({Range to Sum}, {Name Column}, "Bill M", {Month Column}, M@row)

Michele Phillips

That worked! Thank you so much. Formulas are tricky, but luckily I'm able to recycle some of them.

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful so that others searching for a similar solution can know that one may be found here.