Forum Discussion
ledesma92
Feb 03, 2025Copper Contributor
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?
- ledesma92Copper 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.
- ledesma92Copper Contributor
I tried that too. that's what I originally thought, and it worked for some, but not all. :/
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?