# Formula must not use the same row every time

**URL:** <https://community.thunkable.com/t/formula-must-not-use-the-same-row-every-time/2399343>\
**Category:** Questions about Thunkable X\
**Created:** [May 2, 2023, 8:11am UTC](https://community.thunkable.com/t/formula-must-not-use-the-same-row-every-time/2399343 "2023-05-02T08:11:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\
**Post date:** [May 2, 2023, 8:11am UTC](https://community.thunkable.com/t/formula-must-not-use-the-same-row-every-time/2399343/1 "2023-05-02T08:11:46Z")

</div>

I did take all my formulas out of my google sheet, and add this to my block =SUM(C44-C45), but how can I change so when I add new data it does not use the same row c44-c45)

I did get to a point that it nearly work, but it adds them together and not subtrack them from each other.  
=SUM(INDIRECT(“C”&ROW()+1&“:C”&ROW()-1))  
 ![Screenshot_85](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/5/254768994b4dd36e20345617ac94debf46c5daba.png)

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [May 2, 2023, 1:04pm UTC](https://community.thunkable.com/t/formula-must-not-use-the-same-row-every-time/2399343/2 "2023-05-02T13:04:32Z")

</div>

Hello @hendrikbez

> [@hendrikbez](#):
>
> =SUM(INDIRECT(“C”&ROW()+1&“:C”&ROW()-1))

You could do the calculation on the app and send the correct number of row to the table using the join block. Could you please see the screenshot?

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/6/1653c953ad095d975eaa4e4015b5598c25351e69.png)

---

<div class="post-metadata">

**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\
**Post date:** [May 2, 2023, 5:10pm UTC](https://community.thunkable.com/t/formula-must-not-use-the-same-row-every-time/2399343/3 "2023-05-02T17:10:16Z")

</div>

Thank you

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [July 31, 2023, 5:11pm UTC](https://community.thunkable.com/t/formula-must-not-use-the-same-row-every-time/2399343/4 "2023-07-31T17:11:00Z")

</div>

Closed on July 31, 2023, 5:11pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.