formula results in the status bar

  • Thread starter Thread starter Matt S
  • Start date Start date
M

Matt S

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?
 
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
 
Back
Top