Formula for Avoiding totals of Duplicate Information

G

Garbage Man

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.
 
J

Jim Cone

Insert or use an empty column to the left of your data set.

In that column use the formula... "=COUNTIF(D5:$D$19,D5)" and fill down.
The above assumes invoice IDs in D5:D19 (note the use of $).

Assuming the above formulas are in column C and the amounts to total
are in column E, then your "Total" formula is... =SUMIF(C5:E19,"=1",E5:E19)

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Garbage Man"
wrote in message
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top