Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
"countif" from multiple worksheets within workbook | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions | |||
CountIF across multiple sheets in a workbook | Excel Worksheet Functions |