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.