Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional SUMIF | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |