Results 1 to 3 of 3

Thread: SUMPRODUCT has mismatched range sizes
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2017
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default SUMPRODUCT has mismatched range sizes

    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 by gammaves; Sep 30th, 2019 at 12:20 PM.

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,993
    Post Thanks / Like
    Mentioned
    53 Post(s)
    Tagged
    6 Thread(s)

    Default Re: SUMPRODUCT has mismatched range sizes

    That formula doesn't really make sense as you're trying to multiply text values. What are you actually trying to do?

  3. #3
    New Member
    Join Date
    Mar 2017
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUMPRODUCT has mismatched range sizes

    =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!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •