Here is the formula I am trying to use on a worksheet called Reports.

=SUMPRODUCT(('M&I'!A3:A18=Data!E2)*('M&I'!B3:B20=R eports!B19)*'M&I'!E3:E36)

Data Key:

(Array1)
'M&I'!A3:A18=column of dates
Data!E2=Today()

(Array2)
'M&I'!B3:B20=column of customer names
Reports!B19=list box where the users can select a customer name

'M&I'!E3:E36=I want to total this column based on the criteria matched
by the arrays.

An example would be
where (date=1/13/06 and customer=ME) amount=$100.00

Thanks in advance!

Robert Palmer
Sr. Systems Specialist
VECTORsgi, INC