agwalsh
asked on
Sum in excel based on cell colour
hi Folks
Is there a way to sum a range based on its colour e.g. in the attached sheet. All the yellow cells added up together are 500. Is there some way to use the Sumif or some other way to automatically add up cells based on their colour. Thanks.
sum-based-on-colour.xlsx
Is there a way to sum a range based on its colour e.g. in the attached sheet. All the yellow cells added up together are 500. Is there some way to use the Sumif or some other way to automatically add up cells based on their colour. Thanks.
sum-based-on-colour.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Does exactly what it says on the tin. If using this, make sure you put the function in the cell with the colour you want to sum by.
ASKER