View Single Post
  #1   Report Post  
shmurphing
 
Posts: n/a
Default SUMPRODUCT formula

I need to have a fomula that will take the data in column B that are producta
or productb and classified as enduser and and add the time of delivery. As a
end result I want the total time of delivery for those rows that fall under
those categories. So far, I have

=SUMPRODUCT(--('sheet1 data'!B6:B500="ProductA"),--('sheet1
data'!C6:C500="EndUser"))

Suggestions on how I can complete this formula?