Results 1 to 11 of 11

Excel 2007 : Count based on year in a row of dates

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2011
    Location
    Washington, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Count based on year in a row of dates

    I have an Excel file that lists a date that corresponds to each time a photo was used. I need to count the usage based on a specified year, but haven't found the right function to do this. Here's a rough example:

    Photo name | Usage | Date(C | Date(D) | Date(E)

    MyDog.jpg | #here | 1/1/2010 | 3/7/2010 | 1/21/2011

    The usage column needs a function that counts the number of uses in 2010 based on columns C, D and E (there are actually columns out to Z). So, in this example, the number in the usage column should be 2.

    I've tried COUNTIF and SUMPRODUCT, but so far have been unsuccessful. Thanks in advance for any help you can provide.

    Kevin
    Last edited by Dadoo; 01-25-2011 at 02:51 PM.

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