Problem with SUMPRODUCT and Arrays

  • Thread starter Thread starter rcpalmerii
  • Start date Start date
R

rcpalmerii

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=Reports!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
 
Your arrays must be the same size to use SUMPRODUCT. Though each of
the three starts on the same row they all end at different rows
indicating that some are longer than the others.

- John Michl
 
John,

Thank you so much! That was the issue. When selecting my ranges I
just grabbed a few cells from each row that I needed.

Robert
 
Back
Top