Thread: SumProduct?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JP[_5_] JP[_5_] is offline
external usenet poster
  
Posts: 4
Default SumProduct?
The following formula will sum two columns if th criteria is met in
the first column, but it won't sum three coumns. Any suggestions?

=SUMPRODUCT((F20:F2000=6.5)*(P20:P2000+Q20:Q2000))

=SUMPRODUCT((F20:F2000=6.5)*(P20:P2000+Q20:Q2000+r 20:r2000))

Reply With QuoteReply With Quote