SUMIF + Conditional Formatting
 

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

SUMIF + Conditional Formatting
 

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

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