Good day.
I wander how to write all variable and row in A1, A2… to use in function SUMIFS?
when i put a column name it’s act as F:F in googlesheet or as F{row number} ?
Please help
Best regards
Andrey
I wouldn’t use Hyperformula for this. You should be able to do it with a combination of:
- If-Then-Else column - return value only if it matches your condition.
- Rollup - Sum that If-Then-Else column.
6 Likes
i don’t understand how it possible. if-then-else check condition in single row (both in row variable and what we check) or each row with constant (constant, that we put in column condition)
so, i need take variable in each row, and for them find all apropriate rows. i can do it if manually make same cuantity column as rows 
and this only for one condition. for second i must repeat add more column.
Just for example: make a sheet where in row: “random betwin 1 and 10” then “random month” and “random hour”. need calculate and write summ of row, where month same that in present row and hour less than in present row.
in Glide say that this formula (SUMIFS) could be used. how?
SUMIFS is not possible in Glide as it is used in google sheets. But, it can easily be recreated in Glide using IfThenElse - Rollup columns combination. Now, it depends on how structured your data is.
I’ll try to give you an example of how I’m using it:
- I have a table where teachers are grading their students. All the students are gathered at one simple table where you’ll find: student name, subject, grade, grade category, date, teacher who entered the grade, and semester. Those are basic columns populated through a simple grading form which is the same for all teachers. Then, there are ITE columns for each subject (5 of them) and each grade category (also 5 of them). The structure of ITE logic is: if the subject is xxx then xxx, else empty. Or, if the grade category is xxx, then xxx, else empty.
- In the main table where all the students are (which is related to the first table by student name) I’ve created rollup columns that are looking to ITE columns and create average value or count value for each student. Or, it could sum values if needed.
That is my case. There are probably some more creative and easier ways to do it but I hope so this will give you more ideas and understanding of the concept.
3 Likes
Yes.
But if take your example, i have handreds of subjects and handreds categorys. And new one (subjects and category) appear again and again.
So silly, that this function mentioned as possible to use, but it’s not so.
So, for now I see only one clue: move all calculation from Glide to Google, where all cels could be reach.
You’re probably right. If that’s the case. But you should be careful with formulas in GS since it might slow down your app considerably.
Or… I believe there are more experienced Gliders here that can provide you with more valuable information on that subject.
Sorry I couldn’t help.
anyway, thx for your reply!
hope that it will be work in nearest future.
1 Like
Probably I haven’t got the full picture of how are you going to use the SUMIF function. Can you tell us the clear steps and logic of how you’re going to use it and what’s your data structure for now? Thank you.
oh, i try.
i have a list with records. There are appear new rows.
row is: user name, date of record, overal points before this record, achived point during this record.
so SUMIFS must be used in “overal points before this record” - it’s make a summ of “achived point during this record” for user written in this row and same time only records, that was before this records.
in list a lot of user and there appear new users.
all result must be achived by any other users.
So like a running total up until that record for that specific user, right? I think you had better use an ARRAYFORMULA in the Sheet for this.
Hi there…
Here are some screenshots as well as a demo app I created for you where I recreated a solution from my app. I used it as AverageIfs but the principle is the same. I hope it will give you better insight.
2 Likes
Many thanks…i get it now
@Mozza Thank you Igor, going to see