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)