Hi, sorry I’m not too advance with excel so may be an obvious answer to my problem!
I’ve got a budget spreadsheet that has cells with IFS conditions based on how much someone is charged for an event based on their job banding (band 3 pay £45, band 5 pay £50 eg =IFS(B4=3, “45”, B4=5, “50”). So now have a column of how much is due from each person.
Is there a way to add the value of the cells in that column that have this formatting applied to them? Doing a simple =SUM(B4:B99) will give a value of 0 as the cells are conditionally formatted and don’t actually hold the value of 45 or 50 but the IFS condition
I hope this makes sense! Thanks in advance!
I’ve got a budget spreadsheet that has cells with IFS conditions based on how much someone is charged for an event based on their job banding (band 3 pay £45, band 5 pay £50 eg =IFS(B4=3, “45”, B4=5, “50”). So now have a column of how much is due from each person.
Is there a way to add the value of the cells in that column that have this formatting applied to them? Doing a simple =SUM(B4:B99) will give a value of 0 as the cells are conditionally formatted and don’t actually hold the value of 45 or 50 but the IFS condition
I hope this makes sense! Thanks in advance!