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
Count with merged cells 2
Count of visible, non-blank cells only? 8
Excel 2000 4
Count only visible formula results 2
Count from Blank & Non-Blank Cells 2
Count non-blank cells? 8
Excel Sumproduct 0

Top