Multiple SUMIF within a single cell?
Hello, I'm trying to build a template which would allow vendors to log hours against a project and automatically calculate a cost for each task. This calculation looks at the name of the individual reporting hours along with the listing of approved hours for the task then multiplies it against that individual's hourly rate which is stored within the same sheet.
Column Headers for this formula are: Name, Hours Approved, Contact Name, Hourly Rate
One side of this sheet contains a contact list with the Contact Name and Hourly Rate. The other side of the sheet keeps a running list of all logged tasks. Based on who is reporting the task (Column "Name") the formula needs to match it to the matching name (Column "Contact Name") and multiply the reported hours (Column "Hours Approved") by the hourly rate for that particular individual (Column "Hourly Rate").
Right now the formula is built to assume that there are four vendors doing work on this project. I get the following error with it though: #UNPARSEABLE.
=SUMIF(Name1, =[Contact Name]1, [Hours Approved]1 * [Hourly Rate]1), SUMIF(Name1, =[Contact Name]2, [Hours Approved]1 * [Hourly Rate]2), SUMIF(Name1, =[Contact Name]3, [Hours Approved]1 * [Hourly Rate]3), SUMIF(Name1, =[Contact Name]4, [Hours Approved]1 * [Hourly Rate]4)
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!