SubTotal Function - Too complicated

[Adam]

thanks for the formula - =SUMPRODUCT(SUBTOTAL(3,OFFSET
(Ref,ROW(Ref)-MIN(ROW(Ref)),,1))*(Ref=Condition
))

but im new to excel and im not too sure where to put cell
references and conditions.
i want cells R2 to R5001 on a sheet called "Entry" to be
counted if the values in them are above 1.

Adam

 

[Aladin Akyurek]

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Entry!$R$2:$R$5001,ROW(Entry!$R$2:$R$5001)-MIN
(ROW(Entry!$R$2:$R$5001)),,1))*(Entry!$R$2:$R$5001>1))

You could have stayed in the original thread though.

 

[Roger Govier]

Hi Adam

You could try
=COUNTIF(R2:R5001,">1")

Regards
Roger Govier