How to use different =COUNT with Lists

[Guest]

I have a lists of 315 rows on sheet 1. On sheet 2, I have basic stats
functions like COUNT, STDEV, MIN, MODE, MAX, AVERAGE, ETC.

When I filter the list, my counts statistics stay the same, not display the
statistics for the filtered set. SO they show 315 rather than 250, etc. I
have tried Dcount, but I cant get it to work.

If I cant get it to change, I need a way to copy the filtered lists (
remaining entries) and automaticly copy them and past them into a new sheet.

 

[Bob Phillips]

This will get the count assuming column B is filtered, and the count is of
column A

=SUMPRODUCT(SUBTOTAL(3,OFFSET($B$1,ROW($B$1:$B$100)-ROW($B$1),,1))*(ISNUMBER
(A1:A100)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

I have a lists of 315 rows on sheet 1. On sheet 2, I have basic stats
functions like COUNT, STDEV, MIN, MODE, MAX, AVERAGE, ETC.

When I filter the list, my counts statistics stay the same, not display the
statistics for the filtered set. SO they show 315 rather than 250, etc. I
have tried Dcount, but I cant get it to work.

If I cant get it to change, I need a way to copy the filtered lists (
remaining entries) and automaticly copy them and past them into a new

sheet.