Countif

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

 

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

 

[tbd]

That worked brilliantly, Thanks Frank!!

tbd

-----Original Message-----
Hi
try
=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX ($A$1:$A$100,1,1),ROW
.