Google sheets and Google appsheet
I have this formula that I want to use in the header C1 "test"
=ARRAYFORMULA(IF(ISBLANK(F:F), C:C, C:C+F:F))
It must work like this. When there is no data in F it must leave the C value as it is,
but when there is also data in F ,it must then Add C previous row and current row F together and show new value in C current row (if C2 value is 111 and F3 value is 377, then C3 must show 488.
Last edited by hendrikbez; 08-05-2023 at 06:34 AM.
This is a GoogleSheets formula - I shall move this to the correct forum section.
A sample workbook would help ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Perhaps,
C2
=IF(F2="",n(C1),n(C1)+F2)
copied down.
I will be using appsheet, so i need it to work and not do drag it down every time
You have stated GoogleSheets at the top of the opening post. Please change this to Google AppSheets. And provide a link to the worksheet so that people can help you properly and aren't left guessing.
Did change for what is is.
In my sample you can see what I am trying to get it to work.
https://docs.google.com/spreadsheets...it?usp=sharing
It's view only, so nobody can test anything Please share a copy that we can play with.
The error message in C1 suggests that, as in Excel, a cell can contain a formula OR manual entry, which means the values in C need all to be formulae. An array formula can't spill down if there's manually entered data in its way.
If you think it should work differently, please explain why (as I know nothing about AppSheets).
My mistake, i did change it to Be edited now.
I use app sheet to add data in Google sheet, so it cannot be in rows but in header to be used. So if there is any other way to do this, it will be good, as I am now stuck on this for a while
I am struggling to understand what you want. YOu seem to imply in the worksheet that there will be manual (normal?) entry in that column - you can't have both a formula and manual entry.
If you remove everything from C2 and below, the formula spills down. This supports my theory: you cannot have manual entry in that column.
You are correct, that is the problem that I have, I do not know how to get it to work, as in I need it to show both in C, there must be other ways to do this, even if I have to use more columns, but I can not figure this out, so far.
So you are happy for a helper column?
Yes, please, it may help
If your data is all input in F column.
Try this in C1
={"TEST";scan(0,F2:F,lambda(x,y,if(y="",x,x+y)))}
it nearly working, it does count, but now it makes every C row the same value till it gets one with data in F, the keep the same data.
If c2 has 111 in it, and F3 has data (377) in it, then it should show 488 in C3, so it must not change C when not is working. See example in sheet
https://docs.google.com/spreadsheets...it?usp=sharing
use G column as helper column. clean all data in G.
G2
=scan(1,sequence(rows(F2:F),1,2),lambda(x,y,if(index(F:F,y)=0,index(C:C,y),index(C:C,y-1)+index(F:F,y))))
Last edited by windknife; 08-05-2023 at 09:40 AM.
ok, I see what you are trying to do. I am correct with the information here to let you see if you can help me.
I have two different inputs in to the sheet.
So I put 111 in F2 then it must show only that total in C2 for that row.
And if I put 377 in G3, then it must add F2 and G3 together only if there is data in G.
So every day via my app i will add F then, and 1 or t times a month I will need to add data in G
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks