JB,
If the check numbers are in column A, and you put your extents in E1 and E2,
this formula will count them:
=SUMPRODUCT((A1:A65535=E1)*(A1:A65535<=E2))
Don't use A65536! :)
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"JB" wrote in message
...
I am helping someone with a spreadsheet created to track numbered checks
and
i want excel to calculate how many checks are in the numbered series i
provide. (ex. check #1 through and including check #5 would equal 5
checks).
I was going to use an equation of the difference plus 1, but I would
prefer
to use a calculation created by excel for this inclusive counting of
numbered
items.
Thank you!!