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