Hi everyone,
I'm having an issue with one of my formulas.
The formula below works when referencing data in row 13.
But when I try to use the same formula for row 18 I have a #DIV/0! error
=+SUMPRODUCT(--(INDIRECT("'"&CD$5&"'!$E$3:$XDF$3")<=$C$3),INDIRECT("'"&CD$5&"'!$E$13:$XDF$13"))
=+SUMPRODUCT(--(INDIRECT("'"&CD$5&"'!$E$3:$XDF$3")<=$C$3),INDIRECT("'"&CD$5&"'!$E$18:$XDF$18"))
Thank you for any help!
I'm having an issue with one of my formulas.
The formula below works when referencing data in row 13.
But when I try to use the same formula for row 18 I have a #DIV/0! error
=+SUMPRODUCT(--(INDIRECT("'"&CD$5&"'!$E$3:$XDF$3")<=$C$3),INDIRECT("'"&CD$5&"'!$E$13:$XDF$13"))
=+SUMPRODUCT(--(INDIRECT("'"&CD$5&"'!$E$3:$XDF$3")<=$C$3),INDIRECT("'"&CD$5&"'!$E$18:$XDF$18"))
Thank you for any help!