Forum

Notifications
Clear all

How to calculate monthly Sales

4 Posts
3 Users
0 Reactions
72 Views
(@suhail)
Posts: 15
Eminent Member
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
(@fravis)
Posts: 337
Reputable Member
 

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
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Suhail

See if this is what you want.

Sunny

 
Posted : 03/02/2018 10:21 pm
(@suhail)
Posts: 15
Eminent Member
Topic starter
 

Thank you Sunny. This is my desired result. 

 

Regards

 

Suhail

 
Posted : 04/02/2018 8:58 am
Share: