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?
|