formula results in the status bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt S - 27 May 2008 20:21 GMT

I have a worksheet (not mine) which has filters. When I filter I see the
result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar.

How do I get this feature in a spreadsheet I build from scratch?

Reply to this Message

Max - 27 May 2008 22:25 GMT

The status bar numbers are the counts of rows which satisfy the filtered
criteria

Example 1 - single criteria counts
In C1: =COUNTIF(A:A,"Pete")
will return the same number if you had filtered col A for "Pete"

Example 2 - dual criteria counts
In C1: =SUMPRODUCT((A2:A10="Pete")*(B2:B10>10))
will return the same number if you had filtered col A for "Pete" AND col B
for values greater than 10

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I have a worksheet (not mine) which has filters. When I filter I see the
> result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar.
> How do I get this feature in a spreadsheet I build from scratch?

Reply to this Message

FSt1 - 27 May 2008 22:28 GMT

hi
per microsoft, it's buit in. are you having problems somehow?
look here?
http://support.microsoft.com/kb/213886

regards
FSt1

> I have a worksheet (not mine) which has filters. When I filter I see the
> result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar.
>
> How do I get this feature in a spreadsheet I build from scratch?

Reply to this Message

Matt S - 28 May 2008 13:12 GMT

It's easy when you know how. Thanks for the help!

> hi
> per microsoft, it's buit in. are you having problems somehow?
[quoted text clipped - 8 lines]
> >
> > How do I get this feature in a spreadsheet I build from scratch?

Reply to this Message