| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count a red number
How do i count a range of cells that have a red character; like a red 0?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
What determines if something is red? Is it conditional formatting? You could
just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
Just a red 0 for example. Not conditional. I have a list of black and red 0's
in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
Why are some numbers red? That's what John C meant. They're red for a
reason, right? You can write a formula based on the logic of *why* the numbers are red. -- Biff Microsoft Excel MVP "force530" wrote in message ... Just a red 0 for example. Not conditional. I have a list of black and red 0's in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
They are red because the font color was changed, no conditions. I didnt
change them, a spreadsheet was sent to me with these numbers already changed. Because there are more than 26,000 records in this file, I thought I could write a formula to count the number of red 0's to get a quicker result. "T. Valko" wrote: Why are some numbers red? That's what John C meant. They're red for a reason, right? You can write a formula based on the logic of *why* the numbers are red. -- Biff Microsoft Excel MVP "force530" wrote in message ... Just a red 0 for example. Not conditional. I have a list of black and red 0's in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
Ok, then it's complicated!
See these: http://www.cpearson.com/Excel/colors.aspx http://xldynamic.com/source/xld.ColourCounter.html -- Biff Microsoft Excel MVP "force530" wrote in message ... They are red because the font color was changed, no conditions. I didnt change them, a spreadsheet was sent to me with these numbers already changed. Because there are more than 26,000 records in this file, I thought I could write a formula to count the number of red 0's to get a quicker result. "T. Valko" wrote: Why are some numbers red? That's what John C meant. They're red for a reason, right? You can write a formula based on the logic of *why* the numbers are red. -- Biff Microsoft Excel MVP "force530" wrote in message ... Just a red 0 for example. Not conditional. I have a list of black and red 0's in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
If there are no conditions why do you want to count them?
There must be a reason you want to count them and that reason would be the condition? -- Regards, Peo Sjoblom "force530" wrote in message ... They are red because the font color was changed, no conditions. I didnt change them, a spreadsheet was sent to me with these numbers already changed. Because there are more than 26,000 records in this file, I thought I could write a formula to count the number of red 0's to get a quicker result. "T. Valko" wrote: Why are some numbers red? That's what John C meant. They're red for a reason, right? You can write a formula based on the logic of *why* the numbers are red. -- Biff Microsoft Excel MVP "force530" wrote in message ... Just a red 0 for example. Not conditional. I have a list of black and red 0's in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
I realized it would be, just figured someone would know.
Thanks ... "T. Valko" wrote: Ok, then it's complicated! See these: http://www.cpearson.com/Excel/colors.aspx http://xldynamic.com/source/xld.ColourCounter.html -- Biff Microsoft Excel MVP "force530" wrote in message ... They are red because the font color was changed, no conditions. I didnt change them, a spreadsheet was sent to me with these numbers already changed. Because there are more than 26,000 records in this file, I thought I could write a formula to count the number of red 0's to get a quicker result. "T. Valko" wrote: Why are some numbers red? That's what John C meant. They're red for a reason, right? You can write a formula based on the logic of *why* the numbers are red. -- Biff Microsoft Excel MVP "force530" wrote in message ... Just a red 0 for example. Not conditional. I have a list of black and red 0's in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
Nevermind
-- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... If there are no conditions why do you want to count them? There must be a reason you want to count them and that reason would be the condition? -- Regards, Peo Sjoblom "force530" wrote in message ... They are red because the font color was changed, no conditions. I didnt change them, a spreadsheet was sent to me with these numbers already changed. Because there are more than 26,000 records in this file, I thought I could write a formula to count the number of red 0's to get a quicker result. "T. Valko" wrote: Why are some numbers red? That's what John C meant. They're red for a reason, right? You can write a formula based on the logic of *why* the numbers are red. -- Biff Microsoft Excel MVP "force530" wrote in message ... Just a red 0 for example. Not conditional. I have a list of black and red 0's in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
If you just want to count the red numbers.........
Select all cells then EditFindFormatFormatFontColorRed and OK Find All. In the "found" dialog box select top entry then SHIFT + End + Downarrow On Status bar right-click and select "Count" Gord Dibben MS Excel MVP On Tue, 14 Oct 2008 12:28:11 -0700, force530 wrote: I realized it would be, just figured someone would know. Thanks ... "T. Valko" wrote: Ok, then it's complicated! See these: http://www.cpearson.com/Excel/colors.aspx http://xldynamic.com/source/xld.ColourCounter.html -- Biff Microsoft Excel MVP "force530" wrote in message ... They are red because the font color was changed, no conditions. I didnt change them, a spreadsheet was sent to me with these numbers already changed. Because there are more than 26,000 records in this file, I thought I could write a formula to count the number of red 0's to get a quicker result. "T. Valko" wrote: Why are some numbers red? That's what John C meant. They're red for a reason, right? You can write a formula based on the logic of *why* the numbers are red. -- Biff Microsoft Excel MVP "force530" wrote in message ... Just a red 0 for example. Not conditional. I have a list of black and red 0's in column A2:A100 and I want to count the number of red ones. "John C" wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. -- John C "force530" wrote: How do i count a range of cells that have a red character; like a red 0? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count a red number
You need VBA code to do that. I have lots of examples, including summing by color, at http://www.cpearson.com/excel/colors.aspx Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 14 Oct 2008 11:33:00 -0700, John C <johnc@stateofdenial wrote: What determines if something is red? Is it conditional formatting? You could just do a count based on the conditional formatting if it is. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| count a number that is less than a number and greater than a numbe | Excel Worksheet Functions | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Linear Mode
