View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ystrumecki@bismarckenterprises.com is offline
external usenet poster
 
Posts: 3
Default counting numbers in a range

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-