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
Hi Rachel
It is better if you could attach your file with some sample data and the expected result.
It will help us to understand your needs better.
Sunny
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
https://www.myonlinetraininghub.com/excel-sumif-and-sumifs-formulas-explained
It sounds like you just need to change the formula to:
=IF(C4=”Staff costs (direct and external)”,M4 *0.15,0)