Results 1 to 6 of 6

getting data from monthly quarter

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2010
    Location
    california
    MS-Off Ver
    Excel 2007
    Posts
    4

    getting data from monthly quarter

    Hi there folks, could use a helping hand here if possible. As of right now i have a column that has dates (mm/dd/yyyy) from lowest to largest. I already set up a formula to tell me how many times a job occurs within a year (2001, 2002, 2003 etc).

    =SUMPRODUCT(--(YEAR(G2:G174)=2001))

    What i need now is instead of giving me all the jobs within one year, i need a formula to give me the jobs within a quater system. So for 2001 how many jobs were between months 01-03, 04-06, 07-09, 10-12. I know i will need at least four rows per year, i really appreciate the help.
    Last edited by andyx181x; 09-28-2010 at 09:35 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