UniqueSum.jpg

Application Support Analyst

Jase Alexander

<div>
HI Subodh<br />
<br />
Thanks so much for this - works perfect !!<br />
<br />
J
</div>


HI Subodh

Thanks so much for this - works perfect !!

J

<div>
You're welcome Jase! Glad it worked as desired.<br />
Thanks for the feedback.
</div>


You're welcome Jase! Glad it worked as desired.
Thanks for the feedback.

<div>
<div class="content wysiwyg-content">
HI Guys<br />
<br />
Hope you can help<br />
<br />
Ive been trying to use SUMIF, SUM PRODUCT with FREQUENCY and MATCH to sum the quantities in stock locations but ignoring duplicate entries<br />
<br />
I have column A and Column B - column A has the stock location which can be repeated several times with the unique stock quantity against the location in Column B<br />
<br />
Ive tried creating a formula to sum the quantities in Column B but only for each unique location so for example, if in column A Stock Location PB12345 is repeated 6 times and has a quantiity of 500 - when the SUMIF runs through the the two columns, it only includes the sum of 500 from PB12345 once and not include the six times its repeated<br />
<br />
Ive attached a sample file and the desired result in cell F1 - the formula im using shows how many times its repeated but not the sum ?<br />
<br />
If you could help I would be very grateful<br />
<br />
J
</div>
</div>


HI Guys

Hope you can help

Ive been trying to use SUMIF, SUM PRODUCT with FREQUENCY and MATCH to sum the quantities in stock locations but ignoring duplicate entries

I have column A and Column B - column A has the stock location which can be repeated several times with the unique stock quantity against the location in Column B

Ive tried creating a formula to sum the quantities in Column B but only for each unique location so for example, if in column A Stock Location PB12345 is repeated 6 times and has a quantiity of 500 - when the SUMIF runs through the the two columns, it only includes the sum of 500 from PB12345 once and not include the six times its repeated

Ive attached a sample file and the desired result in cell F1 - the formula im using shows how many times its repeated but not the sum ?

If you could help I would be very grateful

J

EXCEL SUMIFS formula of two columns removing dupliate entries

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.