
New Member

March 4, 2019

Hiya. I have a list of cost types. If the cost type is Staff Costs, I need to be able to take the value of that staff cost (appears in another cell), find 15 percent of it, and detail what that is in another cell. I’ve got to that point, but it’s taking the value of costs from rows detailing other cost types, which means when I total it in ANOTHER column, it’s adding double.
I don’t know if that makes sense!
But this is what i have so far:
=IF(C4=”Staff costs (direct and external)”,M4 *0.15,M4)
But when I then sum this, as I said, the cells that dont have staff costs as the type are still pulling through, so any total is including this. How do I negate anything BUT staff costs (direct and external) in this formula.
ANY HELP much appreciated! Thank you

VIP

Trusted Members

June 25, 2016


VIP

Trusted Members

June 25, 2016

Hi Rachel
I believe you wanted to only sum values where the cost type is Staff costs (direct and external).
If that is the case, then you can use SUMIFS.
You can refer here for more details on SUMIFS
1 Guest(s)
