Summing column cells based on values in other columns

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove specific cells in a column. 2
Need Help With the SUMPRODUCT Formula !!!!!!!!!!!!!!!!!! 4
Insert columns and values programmatically with IF statement 9
VBA Programming 1
how do i move columns on one sheet to columns on another sheet 1
Preventing a cell value based on change in other field 3
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Multiple SUM's in a column 15

Back
Top