Forum Discussion
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)+S...
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.
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?
