sum hours assigned to a contact on a sheet for a particular month

tlawrence17

Example: I have a project that lasts three months on a project sheet. 

I am required by the client to report out how many hours of work have been completed by each person assigned to a task at the end of each month on a dashboard

So for example: I need a formula that is going to Find all columns assigned to the contact "Timothy Lawrence" in August (Finish date column) and total those hours

Here is where I am getting stuck...

=SUMIF(Resource:Resource, FIND("Timothy Lawrence", @cell) > 0, [Actual Hours]:[Actual Hours])

This finds all of the hours worked by Timothy Lawrence on the sheet, however I can't seem to figure out how to narrow it down by the month.

The way I logic it out in my head is: "Sumif resource is Timothy Lawrence and finish date is month 8"

I have tried the formula below but get an Invalid data type:

 =SUMIF(MONTH(8), AND(Resource:Resource, FIND("Timothy Lawrence", @cell) > 0, [Actual Hours]:[Actual Hours])) 

Any thoughts? I'm stuck using the sheet template provided by the client (just adding formula rows to the bottom) so an actual re-write of the sheet isn't possible.

SYSPK

This is where SUMIFS comes in handy since you're summing under more than one condition.

Try =SUMIFS([your actual hours range],[range of column with the names],"Timothy Lawrence",[range of column with the months],8)

And don't forget in all these ranges to put $ signs, so as you drag the SUMIFS formula down, it doesn't adjust the numbers. So it may look like this:

=SUMIFS([Actual Hours]$1:[Actual Hours]$200,[Name]$1:[Name]$200,"Timothy Lawrence",[Month]$1:[Month]$200,8)

The first item in the parenthesis is the range of what you want to add, followed by ranges and criteria for any conditions.