Results 1 to 7 of 7

Count months in a range of cells

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2008
    Location
    Wilmington
    Posts
    26

    Count months in a range of cells

    I have a what seems to be simple problem.

    I have names in column C and dates in column D
    Example

    Lee 5/15/2010
    lee 5/17/2010
    lee 6/2/2010
    lee 7/10/2010
    lee 10/5/2010
    jones 3/2/2010
    jones 5/25/2010
    jones 6/10/2010
    jones 6/30/2010
    jones 8/10/2010


    I want a forumula that will tell me how many units were sold in MAY for LEE
    how many units were sold in June for Jones
    ??? make sense?

    I have about 40 different names with over 2000 rows of results so if i can just get the formula for one, I might be able to handle the rest..
    Last edited by eighty2scrambler; 01-06-2011 at 12:33 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