sum value for the last 12 month
 

hi,

how to sum for the last 12 month value
A1 - 100 : month (mmmyy)
b1 - 100 : my value

thanks

sum value for the last 12 month
 

Presuming col A contains real dates,
you could use something like this to define the desired period clearly

In C1:
=SUMPRODUCT((A1:A100= --"01 Mar 2007")*(A1:A100< --"1 Apr 2008"),B1:B100)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"ramzi" wrote:
how to sum for the last 12 month value
A1 - 100 : month (mmmyy)
b1 - 100 : my value

thanks