SUMIF translate from G Sheets

1

Hello,

Haven’t been able to convert the next formula
(H:H)-sumif(A:A,A:A,L:L)
(the original formula is has ArrayFormula and Ifs statements to make it work for every new row, but it’s not important for the found problem)

Here’s the working example:

image
image.png950×205 28.6 KB

What I want to do:

  • If column A (#) is unique, do H-L
  • If column A (#) is repeated, do H-sum(L)

This is part of a bank statement balance where 1 transaction could be for 1 or many expenses. If not enough expenses are entered or extra expenses are entered, then there’s a remaining balance.

Just pasted the same table and I’m working on it. Feel free to point new ways of doing it.

Thanks in advance.

1 Like
2

I have gone this far after several error attemps:
if(count(thisRow.[#])=1,thisRow.[MONTO ORIGINAL]- thisRow.MONTO,thisRow.[MONTO ORIGINAL]- sum(thisRow.MONTO))

image
image.png1057×388 40.1 KB

3

@ehleal

I don’t fully understand your question, but perhaps have a sense of what you’re trying to accomplish.

Study the formulas in this doc, and see if they give you any ideas that you might be able to use, specifically the formulas in the blue columns.

1 Like
4

Thanks @Ander
The final formula that I’m using now is
thisRow.[MONTO ORIGINAL]-Filter(thisTable,[#]=thisRow.[#]).MONTO.Sum()

image
image.png1040×405 42.4 KB

1 Like