wouldn't the subtotal function work?
=SUBTOTAL(104,Your date range)


Thanks, Gary. You're right, it does.

I tended only to use =subtotal(3,range) and =subtotal(9,range)

Thanks for directing me to this one.

Mark