SUMPRODUCT formula

[Guest]

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?

 

[Bob Phillips]

Assuming the times are in D

=SUMPRODUCT(--((B6:B500="ProductA")+(B6:B500="ProductB")),--(C6:C500="EndUse
r"),D6500)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
if your time values are in column D use:

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

maybe you have to use the custom format
[hh]:mm
for the resulting cell (depending how you store your time values). Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html