I want to lookup the number of hours a resource has booked against a project but need to total the number of hours - what would be the best way to do this? (total mind blank )

Hi Julie,

Have you tried the Data Lookup function which will sum the return

Data lookup 

Michael

I haven't used that one before Michael, I'll give it a go

I can't seem to get this one working - do I need to lookup the values first and then do a sum?

Hey Julie,

If you are looking up values in another table, this should give you the total

If you are simply trying to get the total in the same table then Megan's solutions would work for you.

You could also do a SumIf in the destination table first, and then use a simple lookup of that value from the source table, which would avoid the various.

Hi Julie,

Another method is using a SumIf function:SumIf function 

To calculate the total hours of a unique employee and project relationship, you could create a column that concatenates the two, and use them within the SumIf (along with the column that contains the hours value). Something along the lines of =SumIf(Employee Project Concat,Employee Project Concat,Hours) should pull back a total sum of hours in each row.

Hope this helps!

Megan

I was trying to be too clever and pull the number through & total it at the same time hence why it wasn't working. I've now pulled the original values through to my dataset and then used the SumIf function to get the accurate figure.

Thanks everyone for your help