| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count to end of Range
Is there a way to count to the end of a column when you are not sure how long
the range is? I have functions that use the SUMPRODUCT to count various series of data in other worksheets, but each month new data is added to those worksheets and I have to keep editing the functions. Otherwise I have to use set the functions to count out well beyond the data which is slowing down Excel. Any help would be apprechiated. Using Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Using a count in a range name | Excel Discussion (Misc queries) | |||
| Sum or Count using set range | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Threaded Mode
