Hi,

Using Excel 2003. I have 2 worksheets. One with data as list; the other I
want to use as summary.

I've used the sumproduct which works for column b title for aging <30 and
for column G for aging 120, but I need to adapt formula when the other
columns have a aging range, i.e. 90 and less than <120. I haven't been able
to figure it out. Can some one help? I've tried a few ways by even entering
Sum as an array.
Here is last example, which obviously doesn't work.

SUMPRODUCT((data!$A$2:$A$468=$A$6)*(AND(data!$G$2: $G$46890,data!$G$2:$G$468<121))*(data!$H$2:$H$468 ))

TIA