Hello all,

I am wondering if there is any way to add or subtract values in a range only if they meet a specific formatting criteria. Example: In cell L3, I would like to subtract the values in range E10:E99 if the format is "bold, red". At the same time I would like to add the values in range F10:F99 if the format is "bold, red". As the formatting changes I want it to reflect the changes in L3. What I am trying to do is keep track of total amounts that meet that formatting criteria. Thank you for any help.

Thanx Scott