Countif

T

tbd

Hi, I am trying to use a Countif function on a coloum
A1:A100. I want to count the number of values greater
than zero, which works fine and gives me a Total.
However, I want this total to update when I use
Autofilters, so rather than displaying total count it will
only display the Count Total for the number of Values
greater than Zero that I have filtered down to. Is this
possible?
 
F

Frank Kabel

Hi
try
=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($A$1:$A$100,1,1),ROW
($A$1:$A$100)-ROW(INDEX($A$1:$A$100,1,1)),0))=1),--
($A$1:$A$100>0))
 
Top