I have a worksheet that has over 3,000 rows and I have a COST column that is
shaded when the DATE column is below a certain date (which I used conditional
formating).

Now what I would like to do is added together all the shaded COST fields -
what do I need to write to accomplish this?

Thanks!
Stacey