Results 1 to 5 of 5

Using COUNTIF to return the sum of dates that fall within a Month/Year range.

Threaded View

avidcat Using COUNTIF to return the... 01-20-2010, 09:29 AM
NBVC Re: Using COUNTIF to return... 01-20-2010, 09:32 AM
sweep Re: Using COUNTIF to return... 01-20-2010, 09:35 AM
avidcat Re: Using COUNTIF to return... 01-20-2010, 10:06 AM
NBVC Re: Using COUNTIF to return... 01-20-2010, 10:10 AM
  1. #1
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Using COUNTIF to return the sum of dates that fall within a Month/Year range.

    I want to use a COUNTIF to return the sum of all the dates that fall within a given month/year.

    For example:
    E1 Contains the date July-2009

    Column A has date entries such as July 3, 2009, July 18, 2009, August 4 2009...

    In F1 I want to return the sum of all dates that fall within the month of E1.

    I attached an example, I appreciate any help with this.

    thanks,
    Nick
    Attached Files Attached Files
    Last edited by avidcat; 01-20-2010 at 10:19 AM.

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