How to Countif by Highlight Criteria?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joelio_007 - 19 Feb 2007 16:17 GMT

I need to run a simple Countif in excell but only count entries that are
highlighted. Can anyone help???

Reply to this Message

JE McGimpsey - 19 Feb 2007 17:45 GMT

See

http://cpearson.com/excel/colors.htm

> I need to run a simple Countif in excell but only count entries that are
> highlighted. Can anyone help???

Reply to this Message

ShaneDevenshire - 20 Feb 2007 01:10 GMT

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.

Signature

Cheers,
Shane Devenshire

> See
>
> http://cpearson.com/excel/colors.htm
>
> > I need to run a simple Countif in excell but only count entries that are
> > highlighted. Can anyone help???

Reply to this Message