View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Krish Krish is offline
external usenet poster
 
Posts: 15
Default 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