|
Posted to microsoft.public.excel.programming
|
|
|
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
|