Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to count my packages
Hello all,
I have to enter tracking numbers of our DHL packages into a excel spreadsheet every day. And at tthe end of entering this data, I would like to have excel give me a total count of packages entered. Is this possibe? If so, how? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to count my packages
Use the COUNTA function:
=COUNTA(A1:A25) Modify the range A1:A25 to the range of cells containing the tracking number. -- Kevin Backmann "Steve" wrote: Hello all, I have to enter tracking numbers of our DHL packages into a excel spreadsheet every day. And at tthe end of entering this data, I would like to have excel give me a total count of packages entered. Is this possibe? If so, how? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to count my packages
Select that days rows, and then look at "Count" on the status bar.
Steve wrote: Hello all, I have to enter tracking numbers of our DHL packages into a excel spreadsheet every day. And at tthe end of entering this data, I would like to have excel give me a total count of packages entered. Is this possibe? If so, how? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to count my packages
You could also use Data Subtotals. Use function Count at each change in
Date. "Steve" wrote: Hello all, I have to enter tracking numbers of our DHL packages into a excel spreadsheet every day. And at tthe end of entering this data, I would like to have excel give me a total count of packages entered. Is this possibe? If so, how? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to count my packages
Thanks Nate. This information was very helpful. I even like how it makes my
daily report look as well. Thanks again. "Nate" wrote: You could also use Data Subtotals. Use function Count at each change in Date. "Steve" wrote: Hello all, I have to enter tracking numbers of our DHL packages into a excel spreadsheet every day. And at tthe end of entering this data, I would like to have excel give me a total count of packages entered. Is this possibe? If so, how? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Excel 2007 the same software in all Office packages? | New Users to Excel | |||
Add-on Charting Packages | Charts and Charting in Excel | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |