how do I sumif on a font color in excel 2007?

[edk]

I would like to do a conditional sum of a color coded column of numbers. Is
there any way to do that in Excel 2007?

 

[Teethless mama]

=SUBTOTAL(9,A2:A100)

Select your range > Data >Filter >Filter by color