| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif & ranges consisting of multiple areas
Another reason for the use of a dynamic created range is that in this way cells with "N/A" are already discarded. So they will not mess up the sumproduct calculation (or is there a method to exclude the "N/A" cells from that calculation, other than making an additional row on the sheet?). Jurry. -- Jurry ------------------------------------------------------------------------ Jurry's Profile: http://www.excelforum.com/member.php...fo&userid=8664 View this thread: http://www.excelforum.com/showthread...hreadid=278230 |
| 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 & ranges consisting of multiple areas | Excel Worksheet Functions | |||
Threaded Mode
