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 :)

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.

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.

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!!!

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!!!

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!!!

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 :)