Sum or Sumif BUT exclude duplicate records

[Tami]

ok, i have a spreadsheet with 3 tabs.
On each of these tabs i have records with a dept number in Column A and a
sku in column B. For example, tab A may have purple styles, tab B may have
red styles and tab C may have yellow styles. Throuhout each tab i have
various sub-totals adding skus together BUT the subtotal lines are unique in
that they don't have a dept number or sku number.

So now i need a grand total of all 3 tabs BUT some records are repeated so i
need to avoid "double counting". For example, i could have a style that is
purple and yelllow so appears on two tabs.

so i was hoping to get some assistance in writing a formula that can add all
the skus on the three tabs but exclude the duplidates. so i was hoping a
Sumif or a sumproduct coud be used by saying Sum if dept number>0...but
exclude dupiclatesl..or something like this.

really hoping that this request is clear but please let me know if more
information would be helpful.

thanks much,
tami

 

[Pecoflyer]

HOW TO GET FURTHER HELP WITH A WORKBOO
For further help with it why not join our forums (shown i
the link below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts *so you can add workbook
to better illustrate your problems and get help directly with them.
Also if you do join please post in this thread (link found below) s
that people who have been following or helping with this query ca
continue to do so. :

--
Pecoflye

Cheers -

Firefox 3.5.3 is as slow as possible