View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default counting numbers in a range

Are they always six digit certificate numbers?

" wrote:

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-