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: 4614
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: Velouria, B Leonard, Filipa Almeida, Lorna Henning, Joaquim Amorim, Shoua Lee
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Trevor Pindling
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594
Member Stats:
Guest Posters: 49
Members: 32817
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —