Dynamic named ranges and SumProduct function
Posted by tee on July 22, 2001 6:38 PM
I have the dynamic named range
I am using the SUMPRODUCT to count the types.
Now I am using a dymanic named range and have this error
Any suggestion on how to fix it or is the SumProduct function not able to be used with dynamic ranges.
Many thanks in advance