Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting entries by color code
I have a slew of names I entered into a spreadsheet under a field entitled
"Name", some of which I selected and chose a blue background. The blue colored boxes define those who paid their yearly membership dues. Since not every name is color-coded, how can a get a total of the number of blue colored ones? Since my list exceeds 400, finding a quick way to total them, would really ease my work instead of manually counting them. Thanks. |
#2
|
|||
|
|||
Carmen, have a look here at Chip's site for a way to do it,
http://www.cpearson.com/excel/colors.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Carmen" wrote in message ... I have a slew of names I entered into a spreadsheet under a field entitled "Name", some of which I selected and chose a blue background. The blue colored boxes define those who paid their yearly membership dues. Since not every name is color-coded, how can a get a total of the number of blue colored ones? Since my list exceeds 400, finding a quick way to total them, would really ease my work instead of manually counting them. Thanks. |
#3
|
|||
|
|||
See http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH Bob Phillips "Carmen" wrote in message ... I have a slew of names I entered into a spreadsheet under a field entitled "Name", some of which I selected and chose a blue background. The blue colored boxes define those who paid their yearly membership dues. Since not every name is color-coded, how can a get a total of the number of blue colored ones? Since my list exceeds 400, finding a quick way to total them, would really ease my work instead of manually counting them. Thanks. |
#4
|
|||
|
|||
You've been given some tips on how to proceed, including using VBA macros. But
in the future you'll save yourself a lot of grief if you store data in a column, such as one with Y or N for paid or not, rather than trying to, in essence, store data in formatting. Formatting wasn't intended for that purpose. If you create a column, you can, for example, do SUMIF, AutoFilter, etc. On Mon, 19 Sep 2005 12:35:01 -0700, Carmen wrote: I have a slew of names I entered into a spreadsheet under a field entitled "Name", some of which I selected and chose a blue background. The blue colored boxes define those who paid their yearly membership dues. Since not every name is color-coded, how can a get a total of the number of blue colored ones? Since my list exceeds 400, finding a quick way to total them, would really ease my work instead of manually counting them. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting date entries by month & year | Excel Worksheet Functions | |||
Counting Duplicate Entries | Excel Worksheet Functions | |||
Counting Entries | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |