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.