SUM IF criteria

[roopoop]

Hi

I want to autosum (including recalculation of deletions of cell values) certain cells in a col which are colored eg red or yellow. How do i write the code to sum the values say of just the yellow cells. So far i have got =SUMIF(D5:D10,Cells.Interior.ColorIndex = 6,D5:D10)

The color of the cell relates to a type of activity and the value of the cells is the hours used in that activity. Maybe SUMIF is wrong

 

[VoG]

If the cells are coloured manually try Sum/Count Cells By Fill Or Background Color in Excel

 

[roopoop]

TY - looks pretty straightforward when someone shows you. I've part-tested and it looks as tho its what I need