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...
Don't use sumproduct and sumif formulas together; use one of them, and I will recommend using sumproduct for all conditions to solve it.
so that's what's weird, my other formulas for the same area are pulling numbers, and they're with a sumproduct(sumif( function, but not all the numbers are pulling. I tried getting rid of the Sumproduct( function and leaving it at the Sumif, but it still doesn't pull the right numbers.
