=SUMPRODUCT(--(LARGE((A5,A10,A15,A20,A25),ROW(INDIRECT("1:"&COUN T(A5,A10,A15,A20,A25))))1))


however if you want to sum every 5th cell greater than 1 you can use


=SUMPRODUCT(--(MOD(ROW(A5:A50),5)=0),--(A5:A501))

--
Regards,

Peo Sjoblom


"mmock" wrote in message
...
I am looking for a formula to count specific cells and a range (A5, A10,
A15,
A20 and so on) but only count when the value is greater than $1.00. So if
the value of cell A5 was $1.50, the value of cell A10 was $1.25, the value
of
cell A15 was $0.50 and the value of cell A20 was $2.00 the total count
would
be 3. I'm stumped!