I'm trying to use a =Sumproduct and getting a #VALUE error in Google Sheets.
Here is the formula that I'm using.
=sumproduct(--($B$102:$B$255=A14),(right($C$102:$C$255,2))="AT",A$102:$D$255)
When I use that formula in my main table (positioned at E14), I get the error.
When I place the formula in a random cell outside of my main work area (H114, for example) it returns the proper value.
Does anybody know why it would be doing that?
Thanks!

Here is the formula that I'm using.
=sumproduct(--($B$102:$B$255=A14),(right($C$102:$C$255,2))="AT",A$102:$D$255)
When I use that formula in my main table (positioned at E14), I get the error.
When I place the formula in a random cell outside of my main work area (H114, for example) it returns the proper value.
Does anybody know why it would be doing that?
Thanks!
Last edited: