| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to count Highlited Cells.
Is there a formula to count highlited cells with text in them and give me a
total. Not blank Cells.. When i do conditional format for duplicates.. I noticed it higlights the blanks also. How can i make it so it only counts duplicates "text" not blank cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count Highlited Cells.
hi
excel has a built in function for this. right click the status bar at the bottom. from the pop up, select count. high light any area on the sheet. the count will appear on the status bar. Regards FSt1 "Jman" wrote: Is there a formula to count highlited cells with text in them and give me a total. Not blank Cells.. When i do conditional format for duplicates.. I noticed it higlights the blanks also. How can i make it so it only counts duplicates "text" not blank cells. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count Highlited Cells.
Thanks sooo much!!!
"FSt1" wrote: hi excel has a built in function for this. right click the status bar at the bottom. from the pop up, select count. high light any area on the sheet. the count will appear on the status bar. Regards FSt1 "Jman" wrote: Is there a formula to count highlited cells with text in them and give me a total. Not blank Cells.. When i do conditional format for duplicates.. I noticed it higlights the blanks also. How can i make it so it only counts duplicates "text" not blank cells. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to count Highlited Cells.
you are welcome.
thanks for the feed back regards FSt1 "Jman" wrote: Thanks sooo much!!! "FSt1" wrote: hi excel has a built in function for this. right click the status bar at the bottom. from the pop up, select count. high light any area on the sheet. the count will appear on the status bar. Regards FSt1 "Jman" wrote: Is there a formula to count highlited cells with text in them and give me a total. Not blank Cells.. When i do conditional format for duplicates.. I noticed it higlights the blanks also. How can i make it so it only counts duplicates "text" not blank cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I do a formula to use only the highlited cell's | Excel Worksheet Functions | |||
| Toolbar@bottom used to show sum when I highlited cells-now gone! | Excel Discussion (Misc queries) | |||
| what formula do I use to count right-justified cells in a row? | Excel Worksheet Functions | |||
| Need formula to count specific cells in a row | Excel Worksheet Functions | |||
| need formula to count cells below | Excel Discussion (Misc queries) | |||
Linear Mode
