SubTotal Function - Too complicated

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
=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.
 
Back
Top