Formula worked. Thank you.
I'm curious. What do the dashes mean?

"T. Valko" wrote:

Try it like this:

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


--
Biff
Microsoft Excel MVP


"Jan" wrote in message
...
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