counting numbers in a range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ystrumecki@bismarckenterprises.com - 31 Jul 2007 21:41 GMT

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-

Reply to this Message

Toppers - 31 Jul 2007 21:48 GMT

Are they always six digit certificate numbers?

> Hello Everyone,
>
[quoted text clipped - 11 lines]
> Thanks!
> yv-

Reply to this Message

Toppers - 31 Jul 2007 21:52 GMT

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)

> Hello Everyone,
>
[quoted text clipped - 11 lines]
> Thanks!
> yv-

Reply to this Message

ystrumecki@bismarckenterprises.com - 31 Jul 2007 22:02 GMT

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

Reply to this Message