|
|
#1
05-01-2018, 08:25 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 A Formula that will change a time of day frame based on # of minutes in another column
|
Squint | Excel | 3 | 01-17-2018 01:18 PM |
| Merging 2 different cells containing IF formula & change in cell values based on multiple time frame | jay_excel | Excel | 0 | 07-29-2017 11:04 PM |
| Change Cell Color Based On % Complete | jrfoley3 | Project | 1 | 05-30-2013 05:24 AM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| change values based on cell | ubns | Excel | 1 | 05-21-2012 06:28 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode