+ Reply to Thread
Results 1 to 3 of 3

how to calculate sum between two months?

  1. #1
    Registered User
    Join Date
    11-20-2019
    Location
    nepal
    MS-Off Ver
    office 2016
    Posts
    21

    how to calculate sum between two months?

    Dear all,
    how can we calculate the sum in between two different months, like sum from jan to july.
    to make my question clear I've uploaded sample workbook, please check.

    regards,
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,901

    Re: how to calculate sum between two months?

    Try this:

    =SUMPRODUCT(((SHEET_MONTH&SHEET_YEAR)-($H$1&$I$2)>=0)*((SHEET_MONTH&SHEET_YEAR)-($J$1&$I$2)<=0),SHEET_VALUE)

  3. #3
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    Re: how to calculate sum between two months?

    I3=sumproduct(($a$2:$a$19=i2)*(month(sheet_month&0)>=month(h1&0))*((month(sheet_month&0)<=month(j1&0)))*(sheet_value))

+ 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: 8
    Last Post: 02-20-2014, 05:46 PM
  2. [SOLVED] Looking to calculate months
    By Ltat42a in forum Excel General
    Replies: 4
    Last Post: 10-24-2012, 02:46 PM
  3. [SOLVED] Calculate how many Months have passed
    By johan12 in forum Excel General
    Replies: 2
    Last Post: 03-25-2012, 03:33 PM
  4. Calculate age in months
    By darkobird84 in forum Excel General
    Replies: 1
    Last Post: 03-09-2011, 11:34 AM
  5. Excel 2007 : Calculate years, months, day
    By helpme16 in forum Excel General
    Replies: 10
    Last Post: 01-18-2011, 12:34 AM
  6. Calculate Age in Months
    By Tim Hardison in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-09-2009, 07:42 PM
  7. calculate months
    By Mellefranken in forum Excel General
    Replies: 1
    Last Post: 05-23-2007, 11:45 AM
  8. Calculate 6 Months
    By Jason in forum Excel General
    Replies: 5
    Last Post: 08-18-2005, 08:05 PM

Tags for this Thread

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