Using cell color as criteria for filtering

[Vybrus]

How do I write a formula that only includes cells with a certain color within the range.

Eg. =SUM(A1:A34)...But I only want to add the cells that are shaded green for example.

Thank you.

[VBA Noob]

These links may help

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

http://www.exceltip.com/st/Sum_by_co...Excel/517.html

http://www.xldynamic.com/source/xld....r.html#summing

VBA Noob