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?

Assuming the times are in D

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

--

HTH

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


"shmurphing" wrote in message
...
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?

Hi
if your time values are in column D use:

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"shmurphing" schrieb im Newsbeitrag
...
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?