SUMPRODUCT has mismatched range sizes

gammaves

New Member
Joined
Mar 20, 2017
Messages
16
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!
 
Last edited:

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,509
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
That formula doesn't really make sense as you're trying to multiply text values. What are you actually trying to do?
 

gammaves

New Member
Joined
Mar 20, 2017
Messages
16
=sumproduct(--($B$102:$B$255=A14),(right($C$102:$C$255,2))="AT",A$102:$A$255)

I just found my mistake. I had A:D in the final part of the formula. It should have ready D:D. Whoops!
 

Forum statistics

Threads
1,084,819
Messages
5,380,090
Members
401,646
Latest member
rcom

Some videos you may like

This Week's Hot Topics

Top