+ Reply to Thread
Results 1 to 4 of 4

Query using SubTotals > Count function

Hybrid View

phproxy Query using SubTotals > Count... 09-11-2008, 09:42 AM
NBVC Precede the range in your... 09-11-2008, 09:49 AM
phproxy Ok that counts for dates... 09-11-2008, 09:55 AM
NBVC Not sure I understand...... 09-11-2008, 10:03 AM
  1. #1
    Registered User
    Join Date
    09-11-2008
    Location
    nottingham
    Posts
    17

    Query using SubTotals > Count function

    I have a list of entries in a database, with a date at the beginning of each.

    01/08/2008
    04/08/2008
    05/08/2008
    05/08/2008
    05/08/2008
    05/08/2008
    05/08/2008
    05/08/2008
    06/08/2008
    06/08/2008
    07/08/2008
    07/08/2008
    07/08/2008
    08/08/2008
    08/08/2008
    11/08/2008
    11/08/2008
    12/08/2008
    12/08/2008
    12/08/2008
    12/08/2008
    12/08/2008
    12/08/2008
    12/08/2008
    12/08/2008
    13/08/2008
    13/08/2008
    13/08/2008
    13/08/2008
    13/08/2008
    14/08/2008
    14/08/2008
    14/08/2008
    14/08/2008
    14/08/2008
    15/08/2008
    18/08/2008
    18/08/2008
    18/08/2008
    18/08/2008
    18/08/2008
    19/08/2008
    19/08/2008
    19/08/2008
    19/08/2008
    20/08/2008
    20/08/2008
    20/08/2008
    20/08/2008
    22/08/2008
    22/08/2008
    22/08/2008
    27/08/2008
    28/08/2008
    28/08/2008
    28/08/2008
    01/09/2008
    01/09/2008
    01/09/2008
    01/09/2008
    01/09/2008
    02/09/2008
    02/09/2008
    02/09/2008
    02/09/2008
    02/09/2008
    02/09/2008
    03/09/2008
    03/09/2008
    03/09/2008
    03/09/2008
    04/09/2008
    04/09/2008
    04/09/2008
    04/09/2008
    04/09/2008
    04/09/2008
    05/09/2008
    03/09/2008
    09/09/2008
    09/09/2008
    09/09/2008
    09/09/2008
    10/09/2008
    10/09/2008
    10/09/2008
    10/09/2008
    11/09/2008
    Like so.

    I know how to use the count function so it will say 4 above 10/09/2008 etc.

    But how do i get these count totals on another sheet, within the same spreadsheet?

    Thank you for your time.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Precede the range in your formula with the Sheetname that the database is on, followed by an exclamation mark (!)

    e.g. =Countif(Sheet1!A1:A1000,">10/09/2008")
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    09-11-2008
    Location
    nottingham
    Posts
    17

    Wink

    Ok that counts for dates later than a certain date.

    Is there no way to just show all counts automatically, like can be done using the count function found in data>subtotals?

    Thanks again.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Not sure I understand... Maybe you want to try a Pivot Table?

    That will list your unique dates and can give you a count of each.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofill(?) Function Query
    By carlosbourn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2008, 12:53 PM
  2. Count function to count a specific value.
    By Zboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2008, 12:22 AM
  3. Link together different cells in specific order?
    By Sandman4432 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-03-2008, 05:01 AM
  4. multiple criteria in count function
    By sayasimpson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2007, 04:54 PM
  5. COUNT function
    By Robbie_Digital in forum Excel General
    Replies: 2
    Last Post: 02-26-2007, 10:30 AM

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