Sumif and countif only look at the UsedRange.

so
=Sumif(A:A,1,B:B)

would take no more resources than

=Sumif(A1:A10,1,B1:B10) if the used range ends at row 10. That isn't true
for most other functions. So using $A$68:$A$2000 shouldn't be a
problem.

--
Regards,
Tom Ogilvy


" wrote:

Hi Bob!

Does that not use more memory and/or computation?

Also, the App may well have rather large possible data items.

"Bob Phillips" wrote:

Why not juts use a range bigger than you would ever need?