I dare say this solution won't work because the arrays in SUMPRODUCT must
have the same size.
Correct example is:
=sumproduct(--(A1:A5000="abc-123"),B1:B5000)
HTH
--
AP
"Duke Carey" a écrit dans le message
de ...
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="abc-123"),B1:B1000)
Also, you can create a pivot table off your data & that will give you a
list of all your unique part #s and sum the quatities for each
(DataPivot
table)
"jg53" wrote:
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:
http://www.excelforum.com/member.php...fo&userid=9550
View this thread:
http://www.excelforum.com/showthread...hreadid=532585