# How to get total items in a column
**URL:** https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853
**Category:** Questions about Thunkable X
**Tags:** spreadsheets
**Created:** [July 20, 2022, 6:37pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853 "2022-07-20T18:37:24Z")
**Posts on this page:** 7
**Page:** 2
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [July 27, 2022, 4:56am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/21 "2022-07-27T04:56:17Z")
upon rereading your request it seems like you wish to get the NUMBER OF ITEMS in a column (instead of the sum), i would suggest this block:
however if you need the SUM of all the items in a column that happen to be text, use this function:
and use this block instead:
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [July 27, 2022, 7:15am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/22 "2022-07-27T07:15:07Z")
Yes, you will not find it. You are using StP and connecting to Aitrable using the Airtable component but @zander is talking about the blocks that you will only see once you connect your table using the `Data Source` option in the bottom of the `component tree`.
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 27, 2022, 7:22am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/23 "2022-07-27T07:22:34Z")
Yea,but I would still go with the provided option first
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [July 27, 2022, 7:38am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/24 "2022-07-27T07:38:46Z")
Use this
**[Update]**
This will give you number of items (rows). If you want a running total of all item values let me know to share the codes.
---
### Author:  [@versatile](https://community.thunkable.com/u/versatile)
#### Post date: [July 27, 2022, 2:01pm UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/25 "2022-07-27T14:01:30Z")
i forgot to mention that the base records for multiple user,so therefore if am getting total number of a row,it will be a current user
---
### Author:  [@zander](https://community.thunkable.com/u/zander)
#### Post date: [July 28, 2022, 4:02am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/26 "2022-07-28T04:02:57Z")
Check this post out. If might be exactly what you are looking for.
> [@Add search and filter capabilities using Airtable's API in your app](https://community.thunkable.com/t/add-search-and-filter-capabilities-using-airtables-api-in-your-app/1893509):
>
> Project link: [Project Link](https://x.thunkable.com/projectPage/628cee0c7d44b1001299782c) Purpose/description: Pulling in all data from Airtable can be too much sometimes. pulling in only the data you need, and having it presorted can save you time and processing power in your app. This project filters by Age and Sex, then sorts the data by age ascending. See how data comes in unfiltered when you remove the query parameters! slight_smile Goes well with: Apps powered by airtable.
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [October 26, 2022, 4:03am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853/27 "2022-10-26T04:03:21Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
[Previous page](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853.md?page=1)