Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
72
Views
Topic starter
Dear Friends
I want to know how to calculate monthly sales in attached file columns from U to AF. The sales criteria is sales will realized from the start of 1st installment.
Looking forward for your support.
Regars
Sohali
Posted : 03/02/2018 6:30 am
Not sure if I understand you well.
In the column U to AF you now put the desired answer by hand I think?
If you want in that columns things more automatic, is it possible for you to add a starting month for instance in a new column C?
If that is possible, the formula can use that month as a trigger.
If this is the direction you're looking for, we can provide you with a solution in that way.
Frans
Posted : 03/02/2018 3:09 pm
Hi Suhail
See if this is what you want.
Sunny
Posted : 03/02/2018 10:21 pm
Topic starter
Thank you Sunny. This is my desired result.
Regards
Suhail
Posted : 04/02/2018 8:58 am