Formula to count Highlited Cells.

J

Jman

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.
 
F

FSt1

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
 
J

Jman

Thanks sooo much!!!

FSt1 said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Highlited Cells 3
Select Text to End of Footnote 9
How to count non blank cells with a condition? 1
need help in fine-tuning a formula that removes blank cells in a column range 3
Count with merged cells 2
Excel 2000 4
Word macro that can call cells out of Excel for a find and replace 0
Count Number of Unique Cells That Don't Have Certain Characters 0

Top