Counting for a value in a column, after a Filter is created

P

Paul

I need to caculate the occurance of a number in a column,
AFTER a filter is created. I am using =COUNTIF
(Z1:Z15366,"=1097")

I am trying to calculate the Filter "occurances" total
number of columns. i.e. I filer the database by month,
and I want the total number of columns for the filter.

I am also trying to sum up a column in the filter, a time
column that tracts total time, and just add times for the
created filter
 
F

Frank Kabel

Hi
try for the count formula:
=SUMPRODUCT(($Z$1:$Z$15336=1097)*(SUBTOTAL(3,OFFSET($Z$1,ROW($Z$1:$Z$15
336)-MIN(ROW($Z$1:$Z$15336)),,))))

For the second one use
=SUBTOTAL(9,column_range)
 
F

Frank Kabel

Hi Don
though this won't work on filtered results if the OP only want to count
the visible rows :)
 
Top