Hi
I was hoping for some help with a formula.

I have a list and I have applied conditional formatting that when the
cell has a value of 'Yes' the whole row is colored red.

I am trying to calculate totals but I don't want to include any of the
values from those records which are in red.

Am I better to base it on the column C values???

Sample:
A B C
1 Bob $23.00 Yes
2 Betty $22.00 No
3 Gaye $15.00 Yes
4 Harry $10.00 No

*Assume that Bob & Gaye's records are in Red and I am wanting to
calculate the total in col B

cheers
Debbie