Results 1 to 5 of 5

How can I count and sum entries per date?

Threaded View

  1. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: How can I count and sum entries per date?

    You have to first create a list of unique dates.

    If you have dates that are cumulatively ascending by 1 day, then try entering the first date in a new column, say C2, then copy that date down it should increment by 1 day, then you can apply formula.

    Or you can select column A, and go to Data|Filter|Advanced Filter and select Unique Values Only, select a location like C2 and click Ok. This should give a unique list of dates, then apply formula to this list...

    or you can create a Pivot Table like attached which does all the work for you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1