Thanks Max for the reply, but i'm not sure how would that automate the
process. Is that mean I have to change the range each period? Because the
data comes in for the entire year (13 period), and I only needed to sum what
I need according to my current period.
Toppers example will do the job for now.

Thanks.
--
when u change the way u look @ things, the things u look at change.


"Max" wrote:

Another thought, think you could try using a defined range,
eg define D as:
D: ={"01","02","03"}

Then apply it as:
.......)*(Data!$D$2:$D$2500=D)*(...........

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sahafi" wrote:
I have managed to use an array within that criteria,and get it to work, but
it seems like a manual process, meaning every period I have to change my
formulas to include the new period, and this is going to be tedious as my
workbook is quite long with many formulas and projects. Here's how I got it
to work manually:

.......)*(Data!$D$2:$D$2500= {"01","02","03"})*(...........

Is there a way to have this work automatically?