Log In
Register
Home
select data by multiple columns by a number and cost
Christopher Slobodnik
New Member
Members
Forum Posts: 1
Member Since:
June 9, 2023
June 9, 2023
Offline1
June 9, 2023 - 11:16 pm
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
Mynda Treacy
Admin
Forum Posts: 4772
Member Since:
July 16, 2010
July 16, 2010
Offline2
June 10, 2023 - 9:45 am
Hi Christopher,
Welcome to our forum!
You can use the SUMIFS function for this: https://www.myonlinetraininghu.....-explained
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Hans Hallebeek
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 929
Purfleet: 415
Hans Hallebeek: 352
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Pamela Malthouse
Lila Huron-Albinger
Harry Maxwell
Jie Liu
Susan Lanham
Dhanushka Rathnayake
Rena Towles
Wim Verhaege
Shavirai Mawere
Macarena Verdugo
Forum Stats:
Groups: 3
Forums: 25
Topics: 7093
Posts: 31095
Member Stats:
Guest Posters: 49
Members: 34522
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —