I am having problems with my Sumproduct formula.
If I type the following, it returns a value correctly.
=SUMPRODUCT(($L$5:$DS$5=D$1434)*($I$7:$I$50=$B1441),$L$7:$DS$50)
If I increase the data range, it returns a #N/A error.
=SUMPRODUCT(($L$5:$DS$5=D$1434)*($I$7:$I$500=$B1441),$L$7:$DS$500)
The data range is made up entirely of values.
Thanks
If I type the following, it returns a value correctly.
=SUMPRODUCT(($L$5:$DS$5=D$1434)*($I$7:$I$50=$B1441),$L$7:$DS$50)
If I increase the data range, it returns a #N/A error.
=SUMPRODUCT(($L$5:$DS$5=D$1434)*($I$7:$I$500=$B1441),$L$7:$DS$500)
The data range is made up entirely of values.
Thanks