| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing one column based on criteria from two other columns | Excel Worksheet Functions | |||
| Summing rows based on other column values | Excel Worksheet Functions | |||
| summing up values in a column based on values in 3 other columns | Excel Programming | |||
| summing values in a data table based on criteria in another column | Excel Worksheet Functions | |||
| Summing one column if two other columns' values appear in other sh | Excel Worksheet Functions | |||
Linear Mode
