Hi, and thanks in advance for your help! I am working on a spreadsheet (excerpt from the sheet is attached) where I need to total the values in the "New $" column when the CRN numbers (in the CRN column) match. For instance, if CRN# 34310 has multiple instances, I want that total to show up in column M under total text cost. The CRN numbers constantly change, so it can't be by specific CRN number, it has to just be if they match. See below for an example as well:
CRN
34310 AGAINST THE CLOCK Adobe InDesign 2020: The Professional Portfolio 978-1-946396-36-5 $59.99
34310 AGAINST THE CLOCK ADOBE INDESIGN 2019 978-1-946396-20-4 $59.99
34310 PIPES PRODUCTION FOR GRAPHIC DESIGNERS 978-0-205-68479-3 $52.50
I would need the total of all 3 of the dollar amounts.
I hope this isn't too confusing. Thanks again!
Bookmarks