Thread: [Solved] change formula based upon change of month
View Single Post
 
Old 05-01-2018, 08:25 AM
invgrp2 invgrp2 is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Nov 2011
Posts: 8
invgrp2 is on a distinguished road
Default change formula based upon change of month
I trade the commodities market and at the end of each month I have to manually change the formula to determine the monthly results....see attached xls, cells that are highlighted in yellow (R11, R15, R22, R30).

Is there a way to change the formula so when the month changes the formula will know when to start counting again AND keep the stating point until the month changes again?

Thanks.

Bruce
Attached Files
File Type: xlsx IGT_Forum_1.xlsx (53.9 KB, 14 views)
Reply With Quote