I believe you can put half the cells in one formula and repeat the formula
with the second half of the cells and put a + between the two formulas.
Something like this.
I only used 5 cells but you would use about 17 in each formula. I did not
test it with 17 cells.
=SUMPRODUCT(--(LARGE((A1,A2,A3,A4,A5),ROW(INDIRECT("1:"&COUNT(A1 ,A2,A3,A4,A5))))1))+SUMPRODUCT(--(LARGE((B1,B2,B3,B4,B5),ROW(INDIRECT("1:"&COUNT(B1 ,B2,B3,B4,B5))))1))
HTH
Regards,
Howard
"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!
|