sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
In column A I have a list of unique identifying numbers (codes) of which there may be many of the same code spread intermittently down the column. In column B I have a list of numbers that these codes represent. I want a formula that will add up all the numbers in column B that have the same unique identifier in column A. I tried =sum(if(a2:a1000=a2,b2:b1000)) but it doesn't work? I also highlighted it and press control/shift/enter and it turned into a #N/A
Any suggestions?
Thanks
Any suggestions?
Thanks
Last edited: