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

[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

 

[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)

 

[Don Guillett]

try
=COUNTIF (Z1:Z15366,1097)
or
=COUNTIF (Z1:Z15366,"1097")

 

[Frank Kabel]

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

 

[Don Guillett]

Frank, You're right. I mis-read. As you said, sumproduct will do it.