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

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

=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