counting colords cells with letters in them

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

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 :)
 
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
 
Wow thank you so much!!! I didn't even think of that! I though it would be so
much harder!!!
 
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
 
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.
 
Back
Top