| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Range with Months
=countif(Y9:BV9,"S") I need this range to vary with changing months, many thanks so in Sep it becomes =countif(Y9:BV9,"S") so in Oct it becomes =countif(AA9:BV9,"S") so in Nov it becomes =countif(AE9:BV9,"S") so in Dec it becomes =countif(AH9:BV9,"S") -- T De Villier ----------------------------------------------------------------------- T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647 View this thread: http://www.excelforum.com/showthread.php?threadid=39816 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering changing months with a cell | Excel Worksheet Functions | |||
| changing from days to months | Charts and Charting in Excel | |||
| changing dates into months | Excel Discussion (Misc queries) | |||
| Excel - Changing value of a date by a number of calendar months | Excel Worksheet Functions | |||
| Range Changes with the Months | Excel Worksheet Functions | |||
![T De Villiers[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
