SUMIF + Conditional Formatting
On Jan 31, 11:41*am, "Ragdyer" wrote:
Yes, use the Column C values as the criteria:
=Sumif(C1:C4,"Yes",B1:b4)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"DebbieV" wrote in message
...
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- Hide quoted text -
- Show quoted text -
Thought it may be - many thanks Debbie
|