SUMPRODUCT error formula

[Berna11]

Good evening, I would like your help with error #Valore! On SUMPRODUCT formula
In the file attached the same formula if I calculate line C6: AG6 in cell AI6
It works, while I put it from C7: AG7 in the AJ6 cell by mistake.
I did not understand why.
Thank you

[MarvinP]

Hi berna,

In C7 change your formula to:
=IF(C6>$G$1,C6-$G$1,0)
and pull it across.

SumProduct is having a problem with all your "" and treating them as numbers.

[Berna11]

Ok, I understand the reason
Thanks so much
A greeting to the next