How can I add values from different rows?

I would like to create a virtual column where I can calculate the partial amount invoiced. For example:
DAY AMOUNT PARTIAL INVOICED
1 $10 $10
2 $15 $25
3 $20 $45

Is it possible?

Thank you

0 6 137
6 REPLIES 6

Steve
Participant V

Probably.

And how can do it? I have tried in different ways and the result has always been errorโ€ฆ

Thank you Steve, I actually already created a virtual column with total invoiced but the result is the same for all the rows. I used the formula SUM(Hoja 1[IMPORTE]).
But when I have tried select only (for example) cell G3 from IMPORTE + F2 from TOTAL column it has not worked. Iโ€™m updating the โ€œexcelโ€ formula in the file of driveโ€ฆ

Iโ€™m afraid I have no help to offer with spreadsheet formulas.

Thank you Steve, I also think thatโ€™s impossibleโ€ฆ

Top Labels in this Space