| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting colords cells with letters in them
I am trying to count colored cells that have a letter in them. I have it set
up already that when I type in a letter a colored background shows up in the cell. I have tried many different functions to count the cells but they only work if the cell doens't have a letter in it. So it only works when the cell only has color in it. Please help me!! Thanks :) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting colords cells with letters in them
IMO, on the contrary,
its much easier just to count cells with letters in them Example: =COUNTIF(B2:D4,"L") will return the count of cells within B2:D4 containing the letter "L" (case-irrespective) =COUNTIF(B2:D4,"x") Ditto for letter "x" (case-irrespective) -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "JJ" wrote: I am trying to count colored cells that have a letter in them. I have it set up already that when I type in a letter a colored background shows up in the cell. I have tried many different functions to count the cells but they only work if the cell doens't have a letter in it. So it only works when the cell only has color in it. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting colords cells with letters in them
Wow thank you so much!!! I didn't even think of that! I though it would be so
much harder!!! "Max" wrote: IMO, on the contrary, its much easier just to count cells with letters in them Example: =COUNTIF(B2:D4,"L") will return the count of cells within B2:D4 containing the letter "L" (case-irrespective) =COUNTIF(B2:D4,"x") Ditto for letter "x" (case-irrespective) -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "JJ" wrote: I am trying to count colored cells that have a letter in them. I have it set up already that when I type in a letter a colored background shows up in the cell. I have tried many different functions to count the cells but they only work if the cell doens't have a letter in it. So it only works when the cell only has color in it. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting colords cells with letters in them
Welcome, good to hear. Could you kindly go back to that response and rate it
by pressing the YES button (like the one below) since it answered your query? Thanks. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "JJ" wrote: Wow thank you so much!!! I didn't even think of that! I though it would be so much harder!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting colords cells with letters in them
yep i sure can!!!
"Max" wrote: Welcome, good to hear. Could you kindly go back to that response and rate it by pressing the YES button (like the one below) since it answered your query? Thanks. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "JJ" wrote: Wow thank you so much!!! I didn't even think of that! I though it would be so much harder!!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting colords cells with letters in them
Thanks for pressing all the right buttons ...
Ahhh! That feels good. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "JJ" wrote in message ... yep i sure can!!! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting colords cells with letters in them
Hi,
I would be curious - how did you count the cell colors? Also, I probably missunderstood but you seemed to want to count cells with a certain color AND letter and no spreadsheet function does that. -- Cheers, Shane Devenshire "JJ" wrote: I am trying to count colored cells that have a letter in them. I have it set up already that when I type in a letter a colored background shows up in the cell. I have tried many different functions to count the cells but they only work if the cell doens't have a letter in it. So it only works when the cell only has color in it. Please help me!! Thanks :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting specific letters in multiple cells | Excel Worksheet Functions | |||
| counting letters. | Excel Worksheet Functions | |||
| Counting Letters | Excel Worksheet Functions | |||
| Counting Letters in a Column | Excel Discussion (Misc queries) | |||
| Counting Letters | Excel Worksheet Functions | |||
Linear Mode
