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

Most likely problem is that one of the columns (either old or, most likely,
new) that you think held dates, didn't actually hold dates, but held text
that looks like dates. And since you can't do math with text, #VALUE is
returned.

"Nate" wrote:

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

That was the first thing I tried, but it didn't seem to have any effect.
Plus the sumproduct formula didn't have any direct references to the date
column itself. It only referenced the column containing Q1, Q2, etc...
which was a text based on the date.

"JLatham" wrote:

Most likely problem is that one of the columns (either old or, most likely,
new) that you think held dates, didn't actually hold dates, but held text
that looks like dates. And since you can't do math with text, #VALUE is
returned.

"Nate" wrote:

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