Good Afternoon,
I have a spreadsheet with several hundred different file numbers (Column A). Some of the numbers are listed multiple times on the spreadsheet with different transaftion amounts (Column B) listed. I believe what I need is a SUMIF formula that can somehow calculate the total of the transaction amounts for the corresponding file numbers. I have attached an example of what I am looking for Highlighted in column C. Any help is much appreciated!
Example1.xlsx
Bookmarks