View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Garbage Man Garbage Man is offline
external usenet poster
 
Posts: 1
Default Formula for Avoiding totals of Duplicate Information

I want to calculate a total that avoids certain duplicate information, like
an invoice number that may repeat. I have a list of daily invoices but the
same invoice number may come up twice for various reasons. I only want to
calculate its total once.