Thread
:
Sumproduct returns value error when ref is formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Sumproduct returns value error when ref is formula
I just tested this where col L value is the result of a formula. Perhaps
your Jan needs to be "Jan"
=SUMPRODUCT((J1:J11="jan")*L1:L11)
--
Don Guillett
SalesAid Software
"wx4usa" wrote in message
ups.com...
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??
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett