| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Range Changes with the 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 -- T De Villiers ------------------------------------------------------------------------ T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479 View this thread: http://www.excelforum.com/showthread...hreadid=398140 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| How do I create a range of months in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
