I have a sumproduct formula that was working fine. In my table that it looks
up to 1 of the columns contains a formula that returns Q1, Q2, etc... based
on the date of another column in the table. 1 of the criteria in my
sumproduct formula filters data based on the Q1, Q2 column of my table. I
changed the formula that returns Q1, Q2, etc... so that it returns the same
values based on a date in a different column. For some reason once I do that
my sumproduct formula stops working (returns a #VALUE error)? Any
suggestions would be greatly appreciated. Thanks,

Nate