Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting records
I posted somehting like this last week, but the asnwe Irecieved was to use SUMPRODUCT. Firs I am filtering the record set to match a date range. THen on that subset, I must use any of 3 to 10 different criteria in 2 columns to determine if a record is counted. So if a record matches one of the values in COlE and one of the picked vale in COl I, then it gets counted. I need to do this in VBA. Iif I use the EVALUATE, I can use the formula in code. However, it will not work with name ranges (at least for me). Does anyone know if you can use a named vairable range in SUMPODUCT instead of literal cell references. This needs to be a repeatable process on data that will get refereshed and willnot have the same number of rows. I am not real stroing in VBA. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula For Counting Records | Excel Worksheet Functions | |||
counting records | Excel Programming | |||
counting records | Excel Worksheet Functions | |||
counting records | Excel Programming | |||
Counting records | Excel Programming |