shmurphing

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
revert formula insertion to old method	Don't be a pain in the ass	Setting up and Configuration of Excel	0	January 24th 05 01:49 PM
sumproduct formula	Brian	Excel Worksheet Functions	1	December 12th 04 05:21 AM
Shorten sumproduct formula	Andre Croteau	Excel Discussion (Misc queries)	1	December 11th 04 10:30 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe.	o0o0o0o	Excel Worksheet Functions	6	November 19th 04 03:13 PM
adding two sumproduct formulas together	ski2004_2005	Excel Worksheet Functions	1	November 12th 04 09:08 PM

All times are GMT +1. The time now is 10:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us