Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Highlighted numbers in an area
I have a tough and unusual question that I'm not sure can be done.
I have a spreadsheet that has different cells highlighted in two different colors. I am trying to add up the number of times a highlighted number (of the two colors) appear in a section. I am trying to search A1..AS2 , A4..E26, F4..O8. The two colors to look for a Color index= 39 or 4 Pattern= xlsolid I am looking for a total of highlighted numbers that include both colors. The numbers I would be searching for are from 1-9 and I would like to find out how many 1's, 2's, 3's...etc. Example: #1= 4 times #2= 6 times #3= 0 times #4= 2 times |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
COUNT HIGHLIGHTED CELLS IN A ROW ? | Excel Discussion (Misc queries) | |||
Highlighted Columns Count! | Excel Discussion (Misc queries) | |||
Count Highlighted Rows | Excel Discussion (Misc queries) | |||
Count highlighted cells | Excel Worksheet Functions |