Countif & ranges consisting of multiple areas

[Jurry]

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

 

[Bob Phillips]

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)