View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gwynneth Gwynneth is offline
external usenet poster
 
Posts: 6
Default SUMPRODUCT: Can you use this and sum the values from multiple colu

Current format used is as follows

=sumproduct(--((Range1=Criteria1)*(Range2=Criteria2)*SumRange))

Is there a way of adding in another range to sum subject to the specifed
criteria?

Thank you in advance
--
Gwynneth