counting numbers in a range

Y

ystrumecki

Hello Everyone,

This seems like it should be something so simple, but for some reason
I haven't been able to come up with a solution:

I'm counting gift certificates.

Column A has their numbers, some in ranges like cell A1:
(515003-515010) or just single number like cell A2:(515013). I'd like
for Column B to give me the total number of certificates.

Anyone have any ideas?

Thanks!
yv-
 
T

Toppers

Assuming 6 digit numbers:

in b1:

=IF(LEN(A3)>6,RIGHT(A3,6)-LEFT(A3,6)+1,1)

Copy down to end of column A list

Total Certificates: =SUM(B:B)
 
Top