| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting numbers in a range
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) " 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- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting numbers in a range
THANK YOU THANK YOU THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
| Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
| Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
| Counting if numbers fall within a specified range | Excel Discussion (Misc queries) | |||
| counting a cell range within a range | Excel Worksheet Functions | |||
Linear Mode
