Multiple contacts selected to a task - calculating costs of effort

Simon Cowx

Hi,

I have hourly rates for employees that are in the contact list.

I calculate the costs of tasks assigned to a single contract with with no problem. However where multiple contact are assigned I cannot find a way to split out the contacts selected to then allow me to calculate their costs at individual rates

Fred £10 per hour

Mike £15 per hour

Dave £20 per hour

Task 1 : Fred for 2 hours = £20

Task 2 : Mike & Dave for 1 hour = £35

However for task 2 how do I pull out the names selected as multiple contacts allocated to the task, to allow cost calculation?

Hope the above makes sense!

Thanks

Simon

Paul Newcome

Do you have a table that lists out everyone in one column and their rates in another?

Simon Cowx

Hi Paul, yes thats correct

Paul Newcome

Try this:

=SUMIFS({Table Sheet Money Column}, {Table Sheet Name Column}, HAS([Name Column]@row, @cell)) * [Hours Column]@row