Paste damages formula in autofilter

S

shawb

Formula is merely an if
if(B2 > 0,1,0)
could also probably use countif

nb: I can't use a summation here as some of my macro's use differen
filters in combination with subtotal and sums alread
 
F

Frank Kabel

Hi
if this formula is ion column C (cell C2) try:
=IF(OFFSET(C2,0,-1)>0,1,0)

or
--(OFFSET(C2,0,-1)>0)

But I'm quite sure you could use a SUMPRODUCT formula
insetad. Even with filtered rows. Just provide some more
details about your layout and what you're trying to achieve
 
Top