| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose data Months & Data to Rows | Excel Discussion (Misc queries) | |||
| how to keep previous months' data | Excel Worksheet Functions | |||
| I want to put 1 years data and 1 months data togheter on one char. | Charts and Charting in Excel | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
| Last Months Data!! | Excel Worksheet Functions | |||
Linear Mode
