ExcelBanter - Sum the data for specified months

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum the data for specified months (https://www.excelbanter.com/excel-discussion-misc-queries/152616-sum-data-specified-months.html)

Pras

Sum the data for specified months

Hi,

I want to know if there is a function which can add the amount for last 12
month form the given month. My worksheet contains 2 column i.e. Date
dd/mm/yyy and Amoutn.

Mike H

Sum the data for specified months

Hi,

Data in columns A & B and the monthe to sum ( 1- 12) in c1

=SUMPRODUCT((MONTH(A1:A100)=C1)*(B1:B100))

Mike

"Pras" wrote:

Hi,

I want to know if there is a function which can add the amount for last 12
month form the given month. My worksheet contains 2 column i.e. Date
dd/mm/yyy and Amoutn.

Toppers

Sum the data for specified months

try for 12 months from this month (month of TODAY()):

=SUMPRODUCT(--(TEXT(A1:A20,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MO NTH(TODAY())-12,DAY(TODAY())),"yyyymm")),B1:B20)

"Mike H" wrote:

Hi,

Data in columns A & B and the monthe to sum ( 1- 12) in c1

=SUMPRODUCT((MONTH(A1:A100)=C1)*(B1:B100))

Mike

"Pras" wrote:

Hi,

I want to know if there is a function which can add the amount for last 12
month form the given month. My worksheet contains 2 column i.e. Date
dd/mm/yyy and Amoutn.

All times are GMT +1. The time now is 02:47 PM.