hi, how to sum for the last 12 month value A1 - 100 : month (mmmyy) b1 - 100 : my value thanks
R ramzi Aug 15, 2008 #1 hi, how to sum for the last 12 month value A1 - 100 : month (mmmyy) b1 - 100 : my value thanks
M Max Aug 15, 2008 #2 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
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
