Posted to microsoft.public.excel.worksheet.functions

Krish

external usenet poster

Posts: 15

Sumproduct formula

I have the following columns in a table.
Customer #
Product #
Invoice #
Pack Size

For every Product shipped to a customer we want to charge a lump sum fees
for the number of boxes. I want to see the fees show up only in one line
where the identical Invoice # and Customer # ends. Is it prudent to use
Sumproduct? If so can I have the formula please?

Thanks

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
Sumproduct Formula	SJT	Excel Discussion (Misc queries)	3	September 1st 08 08:55 PM
Nesting a sumproduct formula within a sumif formula.	jerrymcm	Excel Discussion (Misc queries)	2	October 3rd 07 03:35 PM
sumproduct formula	Todd	Excel Worksheet Functions	7	July 2nd 07 09:22 PM
sumproduct formula help	dr350x	Excel Discussion (Misc queries)	1	June 7th 07 01:14 PM
Sumproduct Formula Help	Harley	Excel Discussion (Misc queries)	3	January 6th 07 07:26 PM

All times are GMT +1. The time now is 07:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us