In article <raydaw.25oxga_1144071301.3755@excelforum-nospam.com>,
raydaw <raydaw.25oxga_1144071301.3755@excelforum-nospam.com> wrote:

> =SUM(IF((F3:F83<=16)-(F3:F83<10),1,0)) which works fine but counts the
> hidden rows.

Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(F3:F83,ROW(F3:F83)-ROW(F3),0,1)),--(F3:F83>
=10),--(F3:F83<=16))

>... what is the purpose of the -- at the start?

Have a look at the following link...

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

Hope this helps!