+ Reply to Thread
Results 1 to 4 of 4

Sum of values for a date column monthwise

  1. #1
    Registered User
    Join Date
    07-30-2008
    Location
    Bangalore
    Posts
    10

    Sum of values for a date column monthwise

    Dear All,

    I want the sum of effort for each month in the summary sheet, please help it's urgent.

    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    you need an array formula
    =SUM(IF(MONTH(Efforts!K6:FE6)=1,Efforts!K7:FE7,0)) confirmed with ctrl+shift+enter will sum all efforts in january for row 7
    you would have to do this for each month then sum those based on catogary in col B i made a start for you by using some helper column to give totals required on efforts_summary.
    note that you can only have this for one complete 12 month period as the formula would not differentiate say between jan 2008 and jan 2009
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Can u explain what help u require?

    I am not able to understand your file and what help you require in the file?

  4. #4
    Registered User
    Join Date
    07-30-2008
    Location
    Bangalore
    Posts
    10

    Thanks Martin it's done

    Thanks for your help it's done
    Quote Originally Posted by martindwilson View Post
    you need an array formula
    =SUM(IF(MONTH(Efforts!K6:FE6)=1,Efforts!K7:FE7,0)) confirmed with ctrl+shift+enter will sum all efforts in january for row 7
    you would have to do this for each month then sum those based on catogary in col B i made a start for you by using some helper column to give totals required on efforts_summary.
    note that you can only have this for one complete 12 month period as the formula would not differentiate say between jan 2008 and jan 2009

+ Reply to Thread

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