Results 1 to 3 of 3

Sum specific monthly columns (i.e. Jan - Oct or Apr - Jun)

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    20

    Sum specific monthly columns (i.e. Jan - Oct or Apr - Jun)

    I have monthly data which and am looking to extract specific data ranges such as Jan - Oct or Apr - Sept., but I need to be able to instruct the formula as to how many months to total.

    i.e. Need sum of Jan - Oct to be 81 for the ID for Atlantic (81) or sum Jan - Apr for same (27)

    I have attempted to use sumif and sumproduct but I am obviously missing something, any help would be greatly appreciated.



    ID Name Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec

    A625088188E102F2 Atlantic 7 6 7 7 7 10 4 11 7 7 4 4
    D03461E15BCA35A3 Southern 2 4 1 3 2 12 7 4 1 6 8 4
    7BBFC8FAEC53948B Florida 8 4 5 2 4 4 5 10 6 4 1
    59C69C4C7E1B18FB Bayside 22 10 17 13 7 14 14 10 14 8 11 12
    587891C4EC264742 B AND R 1 10 12 13 6 5 1 9 12 15 14 5
    AE2394BBB3BE00C0 Better Buns 4 12 6 3 2 5 4 4 4 7 3 4
    FE2D38105D96ACF2 COUNTY 18 18 14 12 15 11 11 12 12 21 17 11
    16E0C5E041CC9E76 BURNSIDE 5 7 7 7 8 7 3 16 9 9 8 7
    C7CE3043C1D0F483 C & C 19 15 21 27 26 35 30 36 35 36 38 31
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 09-20-2017, 02:09 AM
  2. sum monthly amount columns to quarterly columns in separate worksheet
    By rirunnels in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-10-2015, 11:27 AM
  3. Calculate the monthly payment for a specific time period
    By Barni01 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-17-2014, 09:24 AM
  4. Replies: 1
    Last Post: 08-15-2013, 02:15 PM
  5. Replies: 8
    Last Post: 04-04-2013, 08:02 PM
  6. Replies: 1
    Last Post: 07-11-2008, 05:57 AM
  7. Changing Monthly Columns into Quarterly Columns
    By jchao in forum Excel General
    Replies: 1
    Last Post: 06-03-2008, 03:10 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