Forum Discussion

ledesma92's avatar
ledesma92
Copper Contributor
Feb 03, 2025

not pulling all numbers

So I've managed to get my formula working, I'm using 

=SUMPRODUCT(SUMIF(Monday!A17:A40,H19,Monday!E17:E40)+SUMIF(Tuesday!A17:A38,H19,Tuesday!E17:E38)+SUMIF(Wednesday!A17:A41,H19,Wednesday!E17:E41)+SUMIF(Thursday!A17:A33,H19,Thursday!E17:E33))

but for some reason, it's not pulling all the numbers (E17:E40) that correspond with the names (A17:A40).

what am I doing wrong?

  • ledesma92's avatar
    ledesma92
    Copper Contributor

    I need to pull numbers from every day of the week and add them together by similar strain. if that makes sense?

    also, thank you so much for your help, you solved my other question, and I really appreciate any help I can get.

  • Check whether the names in Monday!A17:A40 really match the value of H19. Perhaps there is an extra space? For example, "James" does not match "James " but they look the same.

    • ledesma92's avatar
      ledesma92
      Copper Contributor

      I tried that too. that's what I originally thought, and it worked for some, but not all. :/

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources