Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Thanks for replying. The problem is that my range can consist of A LOT of areas, which would mean a very long formula of sumproduct entries (but of course it is possible to program it, I will if there is no other option...). The second suggestion to define the areas using 1 name does not work. It still gives an error.... Jurry. -- 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 | |
|
|
![]() |
||||
Thread | Forum | |||
How to Link named ranges from multiple Workbooks into a single Wo. | 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 & ranges consisting of multiple areas | Excel Worksheet Functions | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions |