Summing column cells based on values in other columns
 

How do I sum the values in a cloumn based on the values in two other columns.
I tried this:
=SUMPRODUCT(--('Deferred "From" List Details'!$I$2:$I$4783=$A5),--('Deferred
"From" List Details'!$B$2:$B$4783=$B$2),--('Deferred "From" List
Details'!$L$2:$L$4783<""))

but it only counts the number of rows

Summing column cells based on values in other columns
 

read up on array formula on Chip Pearson's web site

http://www.cpearson.com/Excel/ArrayFormulas.aspx


"Ayo" wrote in message
...
How do I sum the values in a cloumn based on the values in two other
columns.
I tried this:
=SUMPRODUCT(--('Deferred "From" List
Details'!$I$2:$I$4783=$A5),--('Deferred
"From" List Details'!$B$2:$B$4783=$B$2),--('Deferred "From" List
Details'!$L$2:$L$4783<""))

but it only counts the number of rows

Summing column cells based on values in other columns
 

Thanks.

"Patrick Molloy" wrote:

read up on array formula on Chip Pearson's web site

http://www.cpearson.com/Excel/ArrayFormulas.aspx


"Ayo" wrote in message
...
How do I sum the values in a cloumn based on the values in two other
columns.
I tried this:
=SUMPRODUCT(--('Deferred "From" List
Details'!$I$2:$I$4783=$A5),--('Deferred
"From" List Details'!$B$2:$B$4783=$B$2),--('Deferred "From" List
Details'!$L$2:$L$4783<""))

but it only counts the number of rows