# Calculating the average of numbers in a column that updates as the data changes

**URL:** <https://community.glideapps.com/t/calculating-the-average-of-numbers-in-a-column-that-updates-as-the-data-changes/64592>\
**Category:** Ask for Help\
**Created:** [August 1, 2023, 4:03pm UTC](https://community.glideapps.com/t/calculating-the-average-of-numbers-in-a-column-that-updates-as-the-data-changes/64592 "2023-08-01T16:03:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SimonD](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@SimonD](https://community.glideapps.com/u/SimonD)\
**Post date:** [August 1, 2023, 4:03pm UTC](https://community.glideapps.com/t/calculating-the-average-of-numbers-in-a-column-that-updates-as-the-data-changes/64592/1 "2023-08-01T16:03:15Z")

</div>

Hi All,

I would like to be able to calculate the ‘average’ of a column that updates as data is changed in the rows…any ideas how I can set this up?

Thanks in advance, Simon

 ![Hi All, I would like to be able to calculate the 'average' of a column that updates as data is changed in the rows...any ideas how I can set this up](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/3793e4268b7681196b868538ad753888bf7d5ecb.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 1, 2023, 4:08pm UTC](https://community.glideapps.com/t/calculating-the-average-of-numbers-in-a-column-that-updates-as-the-data-changes/64592/2 "2023-08-01T16:08:29Z")

</div>

Create a new rollup column, and target it at your Overall Average column, taking the average.

---

<div class="post-metadata">

**Author:** ![SimonD](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@SimonD](https://community.glideapps.com/u/SimonD)\
**Post date:** [August 1, 2023, 4:20pm UTC](https://community.glideapps.com/t/calculating-the-average-of-numbers-in-a-column-that-updates-as-the-data-changes/64592/3 "2023-08-01T16:20:34Z")

</div>

Thanks Darren,

I think that might work 😀