PDA

View Full Version : Solved: problem with sum product formula



arnab0711
06-12-2012, 03:16 AM
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
06-12-2012, 04:57 AM
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
06-12-2012, 05:27 AM
thanks its working now .

stanleydgrom
06-12-2012, 11:10 AM
arnab0711,

You are very welcome. Glad I could help.

Come back anytime.

Have a great day,
Stan