Solved: problem with sum product formula

[arnab0711]

Hi,
I have written this sum product formula in Snap Shot sheet,from cells c5:c16
The output is showing '0' though the output should have been something else.

[stanleydgrom]

arnab0711,

Cell C3 contains:
"April "

Remove the trailing space character.


And, try changing the formula in cell C5:

from:
=(SUMPRODUCT((pivot!$B$5:$B$1000=$C$2)*(pivot!$A$5:$A$1000=$C$3)*(pivot!$E$ 5:$E$1000=$B5)*(pivot!$F$5:$F$1000=1)))

to this:
=(SUMPRODUCT((pivot!$B$5:$B$1000=$C$2)*(pivot!$A$5:$A$1000=$C$3)*(pivot!$E$ 5:$E$1000=$B5)*(pivot!$F$5:$F$1000)))

Cell C5 should display:
135500

Then copy cell C5 down to C16.


Have a great day,
Stan

[arnab0711]

thanks its working now .

[stanleydgrom]

arnab0711,

You are very welcome. Glad I could help.

Come back anytime.

Have a great day,
Stan