This is just a direct solution to the problem. Would appreciate if it was followed up with a decent explanation of which function is doing what. I can get my job done using the given formula but I still stand clueless about how the function nest is actually working. Essentially a 'memorize' and not a 'learn how to'.
How can i get sum of each 9 number of column For exmlp. I84 + next 8 column gqp 9th number clumn is v84 like this all till last of column each 9th number value + ... Which type of formula i can use sir.. Please guide ..
How sum if A B C 20 30 40 10 50 90 40 60 30 70 30 60 In the above eg. I want a sum of column C from the Min or Max value of column A or B. As A2 has the first occurrence of min/max value so from there I want the sum of C column (90+30+60) C2 - C4. Please help with this question.
@@smart-office12 Hello Sir, A B C 1.20 40 30 2.(10) 50 [60 3. 20 30 20 4. 50 10 10 5. 60 10 80 6. 30 (90) 50] 7. 20 20 70 In above eg. A2 has minimum value & B6 has maximum value, so from this range 2-6 I want sum of column C2-C6 (60+20+10+80+50). so from the 1st column minimum value cell to 2nd column maximum value cell, I want sum of in-between cells of column C. I have 1000s sets each set of 7 of 3rows with 3 columns to execute in this manner. I m providing one more eg. so that u have better understanding. A B C 1. 50 30 30 2. 60 20 40 3. (30) 10 [50 4. 90 80 60 5. 70 (90) 30] 6. 50 70 20 7. 40 40 10 from min value of column A3(30) to max value B5(90), sum all cells of column C, C3 to C5 that is [50+60+30]. Please help with this question. Thank You.
Very nice trick with Sum-product to sum the alternate rows. A lot more elegant that I thought it would be!
Thank you 🙏
This formula works in libra calc too. very useful video. thank u so much.
Welcome🙏
Thank you for the clarity of information of new formulae
.
Thank you very much, very clever and net solutionn
Welcome 🙏
Thank you for making it easy. Saved time.
Welcome 🙏🙏
Very helpful video sir
Thanks
Great work
Welcome 🙏
great help indeed!
So helpful tips and tricks
Thank you so much sir
Thank you
Thank you very much. It is of great help to me.
Welcome
Very helpful, thank you
Thank you too🙏
Hello, didn't work in second column, result is same with total amount of the first column, but thanks for this video 🙂.
It should work, may be some error happened
Thank you very much.
It's working perfectly.
Welcome
Very usefull..thank you very much
Can I total it by the heading of colomn
This is just a direct solution to the problem. Would appreciate if it was followed up with a decent explanation of which function is doing what.
I can get my job done using the given formula but I still stand clueless about how the function nest is actually working.
Essentially a 'memorize' and not a 'learn how to'.
What if, numbers are in insequence row... Can we use 8nd3x match with sum product.
Brother nice info. i have tried 1st formula workout but 2nd one for odd numbers formula not working
It should work, please share the file to spreadsheetforu@gmail.com if it still does not work.
very good
Also can do it using sumifs
Wonderful video
Hello sir.. in given solution for alternate summation, how to get sum of rep B,D,F,H
This video might help you, if not please let me know
th-cam.com/video/zhxbZqAL300/w-d-xo.htmlsi=M7iscL-q1Sj6PVlf
Thanks! This is so helpful.
Thank you
How can i get sum of each 9 number of column
For exmlp. I84 + next 8 column gqp 9th number clumn is v84 like this all till last of column each 9th number value + ... Which type of formula i can use sir.. Please guide ..
Use this formula, =Sumproduct((mod(column(A3:S3),9)=0)*A3:S3), where A3:S3 is range of data for example and 9 is the nth column to be added
Very informative, thanks
Wc🙏
Sir, can you pls explain how this formula works.
Super sir
Thank you
Hi! How can i sum alternate multiple column?
VERY USEFUL THANKS
Even row formula plz explain
Nice sir mja agya
Hi Sir. Is the divisor always 2?
Yes, its always 2
Yes, its always 2
Sir i made 3 columns amount, paid & diff the formula is not working as mentioned in the video
can you plz send me email mentioning the issue along with the workbook file? I will check and revert back. Email: spreadsheetforu@gmail.com
Very informative ❤️
Please to help me
To extract running subtraction result based on criteria but some row is empty on data
How sum if
A B C
20 30 40
10 50 90
40 60 30
70 30 60
In the above eg. I want a sum of column C from the Min or Max value of column A or B. As A2 has the first occurrence of min/max value so from there I want the sum of C column (90+30+60) C2 - C4.
Please help with this question.
Pls clearify more, min value from which column and max value from which column?
@@smart-office12 Hello Sir,
A B C
1.20 40 30
2.(10) 50 [60
3. 20 30 20
4. 50 10 10
5. 60 10 80
6. 30 (90) 50]
7. 20 20 70
In above eg. A2 has minimum value & B6 has maximum value, so from this range
2-6 I want sum of column C2-C6 (60+20+10+80+50).
so from the 1st column minimum value cell to 2nd column maximum value cell, I want sum of in-between cells of column C.
I have 1000s sets each set of 7 of 3rows with 3 columns to execute in this manner.
I m providing one more eg. so that u have better understanding.
A B C
1. 50 30 30
2. 60 20 40
3. (30) 10 [50
4. 90 80 60
5. 70 (90) 30]
6. 50 70 20
7. 40 40 10
from min value of column A3(30) to max value B5(90), sum all cells of column C, C3 to C5 that is [50+60+30].
Please help with this question.
Thank You.
Sir how to calculate if each month have four column and we want to calculate first row of each month
Please help i have urgent to know how to calculate
Keep 4 in the divisor of Mod function, rest of all same
Please help me when I use this it says that there’s too many arguments
Please Use sumif formula
How to alternate row caculated with formula
Hi, could you more explain the requirement?
Alternate cells ka sum kaise nikale pls help
It says o when i click enter ?? Please help
Please share me the workbook in spreadsheetforu@gmail.com
I will check and revert
one column 1+1+1+1 inka sum next coloumn mein kaise karein
Ni hora is formula se sab same kia tb b
=SUMPRODUCT(B5:M5*($B$4:$M$4=$B$4)) &=SUMPRODUCT(B5:M5*($B$4:$M$4=$C$4)) will solve the problem.
Please sir file dinu practice KO lagi
Plz write a mail to spreadsheetforu@gmail.com