How to Countif by Highlight Criteria?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to run a simple Countif in excell but only count entries that are
highlighted. Can anyone help???
 
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.
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
countifs Function not giving desired result with date criteria 2
CountIf previous cell formula 0
how do I use COUNTIF stmnt if I want to find cells that are red 9
countif using other cell values for 'range' and 'criteria' 4
countifs criteria includes date range 4
If and Countif 2
COUNTIF with text criteria 2

Back
Top