| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Countif by Highlight Criteria?
I need to run a simple Countif in excell but only count entries that are
highlighted. Can anyone help??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Countif by Highlight Criteria?
See
http://cpearson.com/excel/colors.htm In article , Joelio_007 wrote: I need to run a simple Countif in excell but only count entries that are highlighted. Can anyone help??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Countif by Highlight Criteria?
Hi,
If you mean by "highlighted" selected, then note the lower right side of the status bar when you have some values selected - it will say SUM = 1234. Right-click where you see the SUM and change the option to COUNT or COUNT NUMS. If you mean by "highlighed" that the cells have a fill color applied, then you need either a VBA Function or VBA Sub, both will work. -- Cheers, Shane Devenshire "JE McGimpsey" wrote: See http://cpearson.com/excel/colors.htm In article , Joelio_007 wrote: I need to run a simple Countif in excell but only count entries that are highlighted. Can anyone help??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I highlight a cell if it meets year and month criteria | Excel Worksheet Functions | |||
| Highlight a row automatically if a cell meets certain criteria | Excel Worksheet Functions | |||
| match multiple criteria and highlight corresponding row in Excel | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Linear Mode
