Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a column
I have a column of numbers - some with different colors. I'd like to sum
just the green or the red, etc. How do I write a formula that somes only certain colors? Thanks, Curt |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a column
Why are some numbers green and some red?
Write the formula based on *why* the numbers are the color they are. -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I have a column of numbers - some with different colors. I'd like to sum just the green or the red, etc. How do I write a formula that somes only certain colors? Thanks, Curt |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a column
Curt
You don't. But you might be able to write a formula that works with the condition(s) that made/created the colors. Can yo detail those conditions? HTH Otto "Rooky228" wrote in message ... I have a column of numbers - some with different colors. I'd like to sum just the green or the red, etc. How do I write a formula that somes only certain colors? Thanks, Curt |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a column
I manually set certain colors on certain cells. then I re sorted them. But
I still want the sum of the colors I set. "T. Valko" wrote: Why are some numbers green and some red? Write the formula based on *why* the numbers are the color they are. -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I have a column of numbers - some with different colors. I'd like to sum just the green or the red, etc. How do I write a formula that somes only certain colors? Thanks, Curt |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a column
I manually set certain colors on certain cells.
Ok, but you decided to set the color for a *reason*, didn't you? You didn't just decide to randomly color cells. I'm trying to coax the info out of you so you can do this the *easy* way, otherwise, it's complicated: http://www.cpearson.com/Excel/colors.aspx -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I manually set certain colors on certain cells. then I re sorted them. But I still want the sum of the colors I set. "T. Valko" wrote: Why are some numbers green and some red? Write the formula based on *why* the numbers are the color they are. -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I have a column of numbers - some with different colors. I'd like to sum just the green or the red, etc. How do I write a formula that somes only certain colors? Thanks, Curt |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a column
I sorted the column from largest to smallest and then colored the cells that
added up to 80% of the total. Then I want to re-sort the column using an adjacent column showing names. "T. Valko" wrote: I manually set certain colors on certain cells. Ok, but you decided to set the color for a *reason*, didn't you? You didn't just decide to randomly color cells. I'm trying to coax the info out of you so you can do this the *easy* way, otherwise, it's complicated: http://www.cpearson.com/Excel/colors.aspx -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I manually set certain colors on certain cells. then I re sorted them. But I still want the sum of the colors I set. "T. Valko" wrote: Why are some numbers green and some red? Write the formula based on *why* the numbers are the color they are. -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I have a column of numbers - some with different colors. I'd like to sum just the green or the red, etc. How do I write a formula that somes only certain colors? Thanks, Curt |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a column
Ok, for that, then I guess you'll need to use the VBA procedures described
in the link I posted. -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I sorted the column from largest to smallest and then colored the cells that added up to 80% of the total. Then I want to re-sort the column using an adjacent column showing names. "T. Valko" wrote: I manually set certain colors on certain cells. Ok, but you decided to set the color for a *reason*, didn't you? You didn't just decide to randomly color cells. I'm trying to coax the info out of you so you can do this the *easy* way, otherwise, it's complicated: http://www.cpearson.com/Excel/colors.aspx -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I manually set certain colors on certain cells. then I re sorted them. But I still want the sum of the colors I set. "T. Valko" wrote: Why are some numbers green and some red? Write the formula based on *why* the numbers are the color they are. -- Biff Microsoft Excel MVP "Rooky228" wrote in message ... I have a column of numbers - some with different colors. I'd like to sum just the green or the red, etc. How do I write a formula that somes only certain colors? Thanks, Curt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing a column | Excel Discussion (Misc queries) | |||
summing column c based an column a criteria | Excel Worksheet Functions | |||
Summing a Column instead of a Column range | Excel Discussion (Misc queries) | |||
Summing one column based on date in another column | New Users to Excel | |||
Summing a column | Excel Worksheet Functions |