counting numbers in a range

[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 A2515013). I'd like
for Column B to give me the total number of certificates.

Anyone have any ideas?

Thanks!
yv-

 

[Guest]

Are they always six digit certificate numbers?

 

[Guest]

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)

 

[ystrumecki]

THANK YOU THANK YOU THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!