Subtract two specific rows and show the result in a new row

Paddi

Hi all,

I'm currently facing this issue.

I need to do the calculation like this: [difference]=[sum1]-[sum2],  and [sum1] and [sum2] would always be the 9th and the 10th row. it would be simple with formula when the data is shown in column, how can data be subtracted between two rows?

The sample data is as shown below. Only focusing on highlighted ones would be enough. Thank you.

sample.xlsx

ShankerV

Hi @Paddi 

Please use the multi-row formula, but you need to do it repeatedly for many rows.

But however you can easily achieved is using Multi-Field formula.

Many thanks

Shanker V