+ Reply to Thread
Results 1 to 3 of 3

Need formula to sum every 12 cells to get yearly amounts

  1. #1
    Registered User
    Join Date
    06-21-2013
    Location
    west allis
    MS-Off Ver
    Excel 2007
    Posts
    28

    Need formula to sum every 12 cells to get yearly amounts

    I need some help writing a formula to sum every 12 cells in a column to get yearly amounts. i.e. a4:a15 would sum to year 1 & a16:a27 would sum to year 2.

    Please let me know how to adjust my formula. Workbook attached. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: Need formula to sum every 12 cells to get yearly amounts

    Put this in G4:

    =SUMIFS(B:B,A:A,">"&(F4-1)*12,A:A,"<="&F4*12)

    then copy down to G33.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-21-2013
    Location
    west allis
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Need formula to sum every 12 cells to get yearly amounts

    awesome. thanks pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-23-2014, 09:56 PM
  2. Replies: 4
    Last Post: 10-23-2013, 06:16 AM
  3. Formula to take amounts from other sheet with no duplicate amounts
    By Xx7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-06-2013, 04:34 PM
  4. need formula help for only cells with amounts
    By renebarton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2012, 10:44 AM
  5. Replies: 2
    Last Post: 01-24-2009, 05:34 PM

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