Can someone help please?
I have the following formula
=SUMPRODUCT(($F$8:$BQ$27=U38)*ISNUMBER($B$8:$BM$27 ),$B$8:$BM$27)
and it returns a value of 177
Yet on a separate summary sheet (that is linked to read the value of that
cell) the correct value comes up 176.5
Is there a way to prevent this?
Any help would be greatly appreciated.

Thank you