# I want to get a total £ value from all rows from another sheet that contains a specific term
**URL:** https://community.glideapps.com/t/i-want-to-get-a-total-value-from-all-rows-from-another-sheet-that-contains-a-specific-term/77129
**Category:** Ask for Help
**Created:** [October 16, 2024, 10:52am UTC](https://community.glideapps.com/t/i-want-to-get-a-total-value-from-all-rows-from-another-sheet-that-contains-a-specific-term/77129 "2024-10-16T10:52:46Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Mark\_Bailey](https://community.glideapps.com/u/Mark_Bailey)
#### Post date: [October 16, 2024, 10:52am UTC](https://community.glideapps.com/t/i-want-to-get-a-total-value-from-all-rows-from-another-sheet-that-contains-a-specific-term/77129/1 "2024-10-16T10:52:46Z")
I’m trying to track 3 terms on my costs table; Pre / During / Post. Every cost a user inputs into the cost table needs to specify when payment is required (Pre / During / Post).
I want to show this data on the primary job table so I can see how much money is required for ‘Pre / During / Post’
I’m struggling to link them all together, can anyone help?
Happy to provide further details if needed.
Cheers,
Mark
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 16, 2024, 12:02pm UTC](https://community.glideapps.com/t/i-want-to-get-a-total-value-from-all-rows-from-another-sheet-that-contains-a-specific-term/77129/2 "2024-10-16T12:02:03Z")
Should be able to do it with three query columns in the job table to the costs table, followed by 3 Rollup columns to sum the amount from each query.
---
### Author:  [@Mark\_Bailey](https://community.glideapps.com/u/Mark_Bailey)
#### Post date: [October 16, 2024, 1:18pm UTC](https://community.glideapps.com/t/i-want-to-get-a-total-value-from-all-rows-from-another-sheet-that-contains-a-specific-term/77129/3 "2024-10-16T13:18:29Z")
Hey - I’m struggling to do this. Can you share an example of how this works?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 16, 2024, 6:13pm UTC](https://community.glideapps.com/t/i-want-to-get-a-total-value-from-all-rows-from-another-sheet-that-contains-a-specific-term/77129/4 "2024-10-16T18:13:18Z")
Not much to it. Where are you stuck? Do you have screenshots of what you have?
For starters, do you have a query column in your job table with a filter in that column linking the job in the costs table to the job in the job row, along with a filter to get a certain cost type?