"Manos" wrote:
I have the month always in A1
i change it manually
in Column A from A5 till A1500 i have data

Put in AK5: =IF($A$1="","",SUM(OFFSET($X5,,,,$A$1)))
Copy AK5 down to AK1500
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---