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 |
#2
|
|||
|
|||
T,
What rule do you use to determine the range? Are there labels in another row, or dates? HTH, Bernie MS Excel MVP "T De Villiers" wrote in message ... =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 |
#3
|
|||
|
|||
=COUNTIF(CHOOSE(MONTH(NOW()),ref1,ref2,ref3,ref4,r ef5,ref6,ref7,ref8,Y9:BV9,AA9:BV9,AE9:BV9,AH9:BV9) ,"S")
Replace ref1 to ref8 to suit Jan to Aug -- Ian -- "T De Villiers" wrote in message ... =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 |
Reply |
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) |