I have a sumproduct formula set up and it is working. the problem is that the
data it is pulling increases through out the month. When i try to set it up
to look at A:A it does not work. It gives me a #NUM!. If I put A1:A163 it
will work. The problem is today it may go down to 163 in a week it will need
to go down to 1000. How can I set this up so i don't have to keep changing
the formula?