Sum if cell is green

[Pat]

Is there a way sum just the cells that have a green
background?
Thanks!

 

[Frank Kabel]

Hi
one way: use the following user defined function:
Public Function Sum_Color(rng as range,col_index)
Dim ret_value
Dim cell as range
For each cell in rng
If cell.interior.colorindex=col_index then
If IsNumeric(cell.value) then
ret_value = ret_value + cell.value
end if
end if
next
Sum_Col = ret_value
end Function

Call it in your worksheet with:
=SUM_COLOR(B5:B223,4)

 

[JE McGimpsey]

Take a look here:

http://cpearson.com/excel/colors.htm

 

[Bob Phillips]

Pat,

See http://tinyurl.com/yrptr for a detailed technique.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)