Thank you for the clarity of information of new formulae .

Very nice trick with Sum-product to sum the alternate rows. A lot more elegant that I thought it would be!

@increase-work-productivity

Жыл бұрын

Thank you 🙏

great help indeed!

Thank you very much, very clever and net solutionn

@increase-work-productivity

6 ай бұрын

Welcome 🙏

Thank you for making it easy. Saved time.

@increase-work-productivity

Жыл бұрын

Welcome 🙏🙏

Very usefull..thank you very much

Very helpful video sir Thanks Great work

@increase-work-productivity

Жыл бұрын

Welcome 🙏

Thank you very much. It's working perfectly.

@increase-work-productivity

2 жыл бұрын

Welcome

VERY USEFUL THANKS

Very helpful, thank you

@increase-work-productivity

2 ай бұрын

Thank you too🙏

So helpful tips and tricks Thank you so much sir

@increase-work-productivity

2 жыл бұрын

Thank you

Thank you very much. It is of great help to me.

@increase-work-productivity

2 жыл бұрын

Welcome

Thanks! This is so helpful.

@increase-work-productivity

Жыл бұрын

Thank you

Very informative ❤️

Very informative, thanks

@increase-work-productivity

Жыл бұрын

Wc🙏

Wonderful video

very good

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.

Nice sir mja agya

Can I total it by the heading of colomn

Hi! How can i sum alternate multiple column?

Super sir

@increase-work-productivity

2 жыл бұрын

Thank you

Please to help me To extract running subtraction result based on criteria but some row is empty on data

Sir, can you pls explain how this formula works.

Hello, didn't work in second column, result is same with total amount of the first column, but thanks for this video 🙂.

@increase-work-productivity

5 ай бұрын

It should work, may be some error happened

Also can do it using sumifs

Brother nice info. i have tried 1st formula workout but 2nd one for odd numbers formula not working

@increase-work-productivity

3 ай бұрын

It should work, please share the file to spreadsheetforu@gmail.com if it still does not work.

Even row formula plz explain

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 ..

@increase-work-productivity

2 жыл бұрын

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

Please help me when I use this it says that there’s too many arguments

Please Use sumif formula

Hello sir.. in given solution for alternate summation, how to get sum of rep B,D,F,H

@increase-work-productivity

11 ай бұрын

This video might help you, if not please let me know kzread.info/dash/bejne/rJysxLyqca-ZYJM.htmlsi=M7iscL-q1Sj6PVlf

Sir i made 3 columns amount, paid & diff the formula is not working as mentioned in the video

@increase-work-productivity

9 ай бұрын

can you plz send me email mentioning the issue along with the workbook file? I will check and revert back. Email: spreadsheetforu@gmail.com

Alternate cells ka sum kaise nikale pls help

Hi Sir. Is the divisor always 2?

@increase-work-productivity

9 ай бұрын

Yes, its always 2

@increase-work-productivity

9 ай бұрын

Yes, its always 2

Sir how to calculate if each month have four column and we want to calculate first row of each month

@rajnishkumarsingh1922

Жыл бұрын

Please help i have urgent to know how to calculate

@increase-work-productivity

Жыл бұрын

Keep 4 in the divisor of Mod function, rest of all same

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.

@increase-work-productivity

Жыл бұрын

Pls clearify more, min value from which column and max value from which column?

@harsinchh4342

Жыл бұрын

@@increase-work-productivity 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.

How to alternate row caculated with formula

@increase-work-productivity

Жыл бұрын

Hi, could you more explain the requirement?

one column 1+1+1+1 inka sum next coloumn mein kaise karein

It says o when i click enter ?? Please help

@increase-work-productivity

7 ай бұрын

Please share me the workbook in spreadsheetforu@gmail.com I will check and revert

Ni hora is formula se sab same kia tb b

Please sir file dinu practice KO lagi

@increase-work-productivity

2 жыл бұрын

Plz write a mail to spreadsheetforu@gmail.com