Hi everyone, I’m trying to create a tab in google sheets that acts like a bank register with multiple accounts. It would have a sender ID column, a receiver ID column and a transaction amount column. What I’m now trying to build is a column which outputs a balance for the sender at the point the tr…

Hi Ed, I have altered the script and the sheet to make it work. [image] The script now takes the range of values from column D, filter out null values, then determine the next empty row to copy the formula into using autoFillToNeighbour. I have also removed the “bank” rows and add the initial 10…

Multiple criteria sumif array formula with logic

Ask for Help

Jeff_Hager May 18, 2020, 7:07pm 23

1 Like

Topic		Replies	Views
Looking for advanced google sheet formulas Ask for Help	15	1503	March 12, 2020
Array formula summation is not correct Ask for Help	14	459	October 13, 2021
Some functions don't work with Arrayformula Ask for Help	14	359	November 23, 2021
Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help	125	14419	September 9, 2022
Adding Rows Ask for Help	7	341	November 18, 2021

Multiple criteria sumif array formula with logic

Related topics