I am using sumproduct to build a report.

The referenced column has a formula in it. Sumproduct returns a value
error message since there is a formula in the referenced cells.

Example:

Column A Month (entered)
Column B Sales (entered)
Column C Profit Percent (entered)
Column D Profit dollars (results given by formula, column B * column
C)

Here is the problem
=sumproduct((column a=January)*(column d)) This returns Value error
because column D is a formula. If i enter the column D numbers it
calculates fine


=sumproduct((column a =January)*(columnb)) Works fine because column B
is entered and not a formula

Help??