Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Daily Count in Excel

Status
Not open for further replies.
Jul 24, 2007
25
US
I have a spreadsheet that I want to add a daily count to.
i.e. – I want a count of the entries I add to the spreadsheet on a per-day basis.
I have a date column, which I can run a subtotal by each change in day and I get the intended result, however I need to do to that every day to refresh the information.
I would like to add some sort of function/formula to the spreadsheet that can run my count automatically.

Is there a way to do this automatically or perhaps an alternate method to get my results?

Thank you,

Marco
Win XP
Excel 2003
 



Hi,

You have not really provided enought detail to know EXACTLY what you want.

"Is there a way to do this automatically ...?"

PivotTable Wizard
Subtotals Wizard
CountIF formula
StatusBar Aggregations

Take your pick.



Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top