+ Reply to Thread
Results 1 to 3 of 3

counting non blank cells in a date range

  1. #1
    Registered User
    Join Date
    10-30-2014
    Location
    San Marcos, TX
    MS-Off Ver
    2007
    Posts
    5

    counting non blank cells in a date range

    I make entries of orders processed in date order, from oldest to latest. I want to count the number of jobs processed, both by the total on any date AND by total regardless of date. If I use 2 cells to get those answers, what formulas do I use in each cell?

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: counting non blank cells in a date range

    Use the subtotal feature by date with grand totals.

  3. #3
    Registered User
    Join Date
    10-30-2014
    Location
    San Marcos, TX
    MS-Off Ver
    2007
    Posts
    5

    Re: counting non blank cells in a date range

    That will work but I need a formula in 2 cells so I don't have to keep going back and doing the subtotals and removing previous results. That way, I can see the subtotals at any time and continue to input data and see the subtotals update.
    Thanks

+ 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. Counting Blank cells in a range
    By Jackie11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 10:42 PM
  2. [SOLVED] counting blank cells in a range
    By dcoates in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2013, 08:45 AM
  3. Replies: 2
    Last Post: 11-24-2010, 02:47 AM
  4. Excel 2007 : Counting a Date Range + blank cells
    By Rino468 in forum Excel General
    Replies: 3
    Last Post: 11-01-2010, 02:40 PM
  5. Replies: 0
    Last Post: 08-23-2005, 03:43 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