software

I'm not a programming or excel expert but desperately need help with a
problem. I have a huge spreadsheet that has part numbers and quantity.
I need to find the same part number and sum the quantity of that part
number. Can this easily be solved?--
jg53
------------------------------------------------------------------------
jg53's Profile: www.excelforum.com/member.php...foamp;userid=9550
View this thread: www.excelforum.com/showthread...hreadid=532585=SUMIF(A:A,quot;part numberquot;,B:B)

where A is the part number, B is the quantity

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jg53quot; gt; wrote in message
...
gt;
gt; I'm not a programming or excel expert but desperately need help with a
gt; problem. I have a huge spreadsheet that has part numbers and quantity.
gt; I need to find the same part number and sum the quantity of that part
gt; number. Can this easily be solved?
gt;
gt;
gt; --
gt; jg53
gt; ------------------------------------------------------------------------
gt; jg53's Profile:
www.excelforum.com/member.php...foamp;userid=9550
gt; View this thread: www.excelforum.com/showthread...hreadid=532585
gt;
How is your sheet laid out? Are all the part #s in one column and quantities
all in another? Let's say part#s are in col A and quantities in col B

=sumproduct(--(A1:A5000=quot;abc-123quot;),B1:B1000)

Also, you can create a pivot table off your data amp; that will give you a
list of all your unique part #s and sum the quatities for each (Datagt;Pivot
table)quot;jg53quot; wrote:

gt;
gt; I'm not a programming or excel expert but desperately need help with a
gt; problem. I have a huge spreadsheet that has part numbers and quantity.
gt; I need to find the same part number and sum the quantity of that part
gt; number. Can this easily be solved?
gt;
gt;
gt; --
gt; jg53
gt; ------------------------------------------------------------------------
gt; jg53's Profile: www.excelforum.com/member.php...foamp;userid=9550
gt; View this thread: www.excelforum.com/showthread...hreadid=532585
gt;
gt;

I dare say this solution won't work because the arrays in SUMPRODUCT must
have the same size.
Correct example is:
=sumproduct(--(A1:A5000=quot;abc-123quot;),B1:B5000)

HTH
--
AP

quot;Duke Careyquot; gt; a écrit dans le message
de news
gt; How is your sheet laid out? Are all the part #s in one column and
quantities
gt; all in another? Let's say part#s are in col A and quantities in col B
gt;
gt; =sumproduct(--(A1:A5000=quot;abc-123quot;),B1:B1000)
gt;
gt; Also, you can create a pivot table off your data amp; that will give you a
gt; list of all your unique part #s and sum the quatities for each
(Datagt;Pivot
gt; table)
gt;
gt;
gt; quot;jg53quot; wrote:
gt;
gt; gt;
gt; gt; I'm not a programming or excel expert but desperately need help with a
gt; gt; problem. I have a huge spreadsheet that has part numbers and quantity.
gt; gt; I need to find the same part number and sum the quantity of that part
gt; gt; number. Can this easily be solved?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; jg53
gt; gt; ------------------------------------------------------------------------
gt; gt; jg53's Profile:
www.excelforum.com/member.php...foamp;userid=9550
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=532585
gt; gt;
gt; gt;
And SUMPRODUCT is overkill when there is only one condition.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Ardus Petusquot; gt; wrote in message
...
gt; I dare say this solution won't work because the arrays in SUMPRODUCT must
gt; have the same size.
gt; Correct example is:
gt; =sumproduct(--(A1:A5000=quot;abc-123quot;),B1:B5000)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Duke Careyquot; gt; a écrit dans le message
gt; de news
gt; gt; How is your sheet laid out? Are all the part #s in one column and
gt; quantities
gt; gt; all in another? Let's say part#s are in col A and quantities in col B
gt; gt;
gt; gt; =sumproduct(--(A1:A5000=quot;abc-123quot;),B1:B1000)
gt; gt;
gt; gt; Also, you can create a pivot table off your data amp; that will give you a
gt; gt; list of all your unique part #s and sum the quatities for each
gt; (Datagt;Pivot
gt; gt; table)
gt; gt;
gt; gt;
gt; gt; quot;jg53quot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; I'm not a programming or excel expert but desperately need help with a
gt; gt; gt; problem. I have a huge spreadsheet that has part numbers and
quantity.
gt; gt; gt; I need to find the same part number and sum the quantity of that part
gt; gt; gt; number. Can this easily be solved?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; jg53
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; jg53's Profile:
gt; www.excelforum.com/member.php...foamp;userid=9550
gt; gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=532585
gt; gt; gt;
gt; gt; gt;
gt;
gt;

Col A Part #
Col B Qty
Col C this is where we want the sum of the part # to show up--
jg53
------------------------------------------------------------------------
jg53's Profile: www.excelforum.com/member.php...foamp;userid=9550
View this thread: www.excelforum.com/showthread...hreadid=532585exactly what I gave you!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jg53quot; gt; wrote in message
...
gt;
gt; Col A Part #
gt; Col B Qty
gt; Col C this is where we want the sum of the part # to show up
gt;
gt;
gt; --
gt; jg53
gt; ------------------------------------------------------------------------
gt; jg53's Profile:
www.excelforum.com/member.php...foamp;userid=9550
gt; View this thread: www.excelforum.com/showthread...hreadid=532585
gt;

Bob, I copied and pasted your formula into the spreadsheet but when I
drag it down I get nothing but 0's. Am I missing something. Do the
fields have to be formatted as numbers or is general okay?--
jg53
------------------------------------------------------------------------
jg53's Profile: www.excelforum.com/member.php...foamp;userid=9550
View this thread: www.excelforum.com/showthread...hreadid=532585You need to reference the correct part number, like so

=SUMIF(A:A,A1,B:B)

By dragging it down in this way means that many of the sums will be repeated
in column C. May be better to build a list of part numbers in say M1:M100,
and use

=SUMIF(A:A,M1,B:B)

in C1, and drag that down.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jg53quot; gt; wrote in message
...
gt;
gt; Bob, I copied and pasted your formula into the spreadsheet but when I
gt; drag it down I get nothing but 0's. Am I missing something. Do the
gt; fields have to be formatted as numbers or is general okay?
gt;
gt;
gt; --
gt; jg53
gt; ------------------------------------------------------------------------
gt; jg53's Profile:
www.excelforum.com/member.php...foamp;userid=9550
gt; View this thread: www.excelforum.com/showthread...hreadid=532585
gt;