# How to use SUMIFS in Hyperformula? please help **URL:** \ **Category:** Ask for Help\ **Created:** [December 8, 2021, 11:30pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708 "2021-12-08T23:30:55Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [December 8, 2021, 11:30pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/1 "2021-12-08T23:30:55Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 8, 2021, 11:45pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/2 "2021-12-08T23:45:08Z")
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. ---
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [December 9, 2021, 2:51pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/3 "2021-12-09T14:51:47Z")
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? ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [December 9, 2021, 3:24pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/4 "2021-12-09T15:24:59Z")
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: 1. 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. 2. 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. ---
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [December 10, 2021, 9:54pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/5 "2021-12-10T21:54:39Z")
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. ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [December 10, 2021, 10:23pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/6 "2021-12-10T22:23:47Z")
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. ---
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [December 10, 2021, 10:45pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/7 "2021-12-10T22:45:23Z")
anyway, thx for your reply! hope that it will be work in nearest future. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 10, 2021, 11:06pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/8 "2021-12-10T23:06:21Z")
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. ---
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [December 15, 2021, 6:10pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/9 "2021-12-15T18:10:55Z")
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. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 15, 2021, 11:39pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/10 "2021-12-15T23:39:33Z")
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. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [January 6, 2022, 8:36am UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/11 "2022-01-06T08:36:33Z")
Thanks @Mozza , but… Do you have a graphical presentation of this? I still haven’t gotten it ---
**Author:** ![Mozza](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozza/32/34362_2.png) [@Mozza](https://community.glideapps.com/u/Mozza)\ **Post date:** [January 6, 2022, 1:41pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/12 "2022-01-06T13:41:09Z")
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. ![sumifsdemo1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/6153b855deae7e8448fc7d30777236934038fc82.jpeg) ![sumifsdemo2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/7/17373004a8e2f2b017fb27c25b32e213ebcb9277.jpeg) > **[SumIfsDemo](https://sumifsdemo.glideapp.io/)** ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [January 7, 2022, 8:36am UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/13 "2022-01-07T08:36:08Z")
Many thanks…i get it now ---
**Author:** ![ALEKSEI\_BARANOV](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aleksei_baranov/32/33948_2.png) [@ALEKSEI\_BARANOV](https://community.glideapps.com/u/ALEKSEI_BARANOV)\ **Post date:** [January 13, 2022, 1:08pm UTC](https://community.glideapps.com/t/how-to-use-sumifs-in-hyperformula-please-help/35708/14 "2022-01-13T13:08:08Z")
@Mozza Thank you Igor, going to see