Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
95
Views
Topic starter
I am trying to get a breakdown from two columns for cost by a ID. Each row has an ID number in one column and a cost of that ID in another column. I want to be able to search by a ID and then get a cost of that ID . below I would want to search by
ID 2000 and add the total cost from that ID by the Cost column.
Ex.
ID Cost
2000 7.00
2000 3.66
4488 5.85
Posted : 10/06/2023 9:16 am
Hi Christopher,
Welcome to our forum!
You can use the SUMIFS function for this: https://www.myonlinetraininghub.com/excel-sumif-and-sumifs-formulas-explained
Mynda
Posted : 10/06/2023 7:45 pm
