Thank you for the feedback Sunil, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
I found your video to be very helpful. Thanks! One question : if there are blank cells in the column then its not giving correct value. How to tackle that ???
Can you also do an AVERAGEIF for this argument? For example, you had another column callled products, and you wanted to calculate the average sales for last N number split by product? Thanks for your help!
Thank you for the feedback Ubaidillah, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
Thank you for the feedback May, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H
I am trying to find the positive values in one column and average by 4 and so on. when the row values are below 4 row count, it should not average by 4 and to be shown as 0. Can you please help on this? The formula i used is the below =IF(AND(COUNTIF($M$2:M2,M2)>=1,O2
very clear demonstration .. thank you
I have learnt it previously and found it bit confusing. But, Sir, your teaching made it perfectly clear.
Thank you for the feedback Sunil, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
sir your explanation is wonderful , could you please let me know how to calculate first n numbers of days and also skip blank cells if any .
I found your video to be very helpful. Thanks!
One question : if there are blank cells in the column then its not giving correct value. How to tackle that ???
Has anyone found a solution?
Can you also do an AVERAGEIF for this argument? For example, you had another column callled products, and you wanted to calculate the average sales for last N number split by product? Thanks for your help!
loved it
Thank you for the feedback Ubaidillah, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
You the man
Thank you for the feedback May, it helps in keeping me motivated. Kindly subscribe to my RUclips channel RUclips.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
@@Syedhussainipage already did!
@May Sanchez Thank you, May 😊
May almighty keep you blessed.
I am trying to find the positive values in one column and average by 4 and so on. when the row values are below 4 row count, it should not average by 4 and to be shown as 0. Can you please help on this?
The formula i used is the below
=IF(AND(COUNTIF($M$2:M2,M2)>=1,O2