I use conditional formatting to color my rows according to the point
in the sales process that contact is in. I often Filter rows by color.
However, when I do so, if I want to know how many rows I have showing
in that filtered view, I must count them!

Does anyone know of a formula or script that would count how many rows
are visible in the filtered view?

Thanks in advance!

magmike

Use the SUBTOTAL function with the 103 function numbre :
=SUBTOTAL(103,A:A)
or
=SUBTOTAL(103,A:A)-1
to substtract the header cell
Daniel


> I use conditional formatting to color my rows according to the point
> in the sales process that contact is in. I often Filter rows by color.
> However, when I do so, if I want to know how many rows I have showing
> in that filtered view, I must count them!
>
> Does anyone know of a formula or script that would count how many rows
> are visible in the filtered view?
>
> Thanks in advance!
>
> magmike

On Sep 6, 10:50*am, DanielCo <dcolardelle...@free.fr> wrote:
> Use the SUBTOTAL function with the 103 function numbre :
> =SUBTOTAL(103,A:A)
> or
> =SUBTOTAL(103,A:A)-1
> to substtract the header cell
> Daniel
>
>
>
> > I use conditional formatting to color my rows according to the point
> > in the sales process that contact is in. I often Filter rows by color.
> > However, when I do so, if I want to know how many rows I have showing
> > in that filtered view, I must count them!
>
> > Does anyone know of a formula or script that would count how many rows
> > are visible in the filtered view?
>
> > Thanks in advance!
>
> > magmike- Hide quoted text -
>
> - Show quoted text -

That was easy - thanks!