Countif & ranges consisting of multiple areas
 

I'm using the range quite often, so I would prefer to determine the
range only once instead of redetermining it every time again using a
sumproduct formula. So any help on the problem is more than welcome.


--
Jurry
------------------------------------------------------------------------
Jurry's Profile: http://www.excelforum.com/member.php...fo&userid=8664
View this thread: http://www.excelforum.com/showthread...hreadid=278230

Jurry,

I think Frank was suggesting that you plug the different areas into separate
elements of SUMPRODUCT.

However, if VBA, is this what you want?

Union(Range("A1:A10"), Range("C1:C10")).Name = "testrange"
Range("testrange").Select


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jurry" wrote in message
...

I'm using the range quite often, so I would prefer to determine the
range only once instead of redetermining it every time again using a
sumproduct formula. So any help on the problem is more than welcome.


--
Jurry
------------------------------------------------------------------------
Jurry's Profile:
http://www.excelforum.com/member.php...fo&userid=8664
View this thread: http://www.excelforum.com/showthread...hreadid=278230