-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to write the "Sum" function
- Thread starter Excelboo2
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,349
- Office Version
- 365
- Platform
- Windows
If you mean you have part numbers that are numerically 1, but are actual text values such as 0001 and 0000001, and are diffent part numbers, perhaps:
=SUMPRODUCT(--(B1:B1000="000001"),A1:A1000)
but if you want to do this for all your parts, why not a pivot table?
=SUMPRODUCT(--(B1:B1000="000001"),A1:A1000)
but if you want to do this for all your parts, why not a pivot table?
Last edited:
Upvote
0
Excel Facts
Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
