Thread: Summing column cells based on values in other columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ayo Ayo is offline
external usenet poster
  
Posts: 489
Default 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
Reply With QuoteReply With Quote