Wade Smart wrote:
I have a spread sheet with lots of color values:
Blue, White, Red, Orange, Gray, etc
What Im wanting to do is have a cell that keeps a total of how many of
each: Blue = 52, White = 2 etc
I was using something like IF(C2="Red", 1)+IF(C3="Red", 1)+etc
but that obviously gets crazy after a few rows.
How can this be done faster?
Wade
Oh.. I got to thinking about summing and I found count which pointed to
countif: =COUNTIF(C2:C43, "Green")
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
