sum products formula truncates

[mmccra2858]

Please see uploaded example.
When I enter the formula below into C9 of the November Stats sheet it returns the correct number but the formula gets truncated.
Please try the following, clear cell C9 then in the formula bar add this formula, it should return 133. Now take a look at the formula again and you will see that it has been shortened.
I need the whole formula because is there a way to keep it from truncating?

=SUMPRODUCT(--(Archive!K5:K5000="CAP"),--(MONTH(Archive!F5:F5000)=11)
*(Archive!$A$5:$A$5000="5811")*Archive!N5:N5000)/SUMPRODUCT(--(Archive!K5:K5000="CAP"),--(MONTH(Archive!F5:F5000)=11)*(Archive!$A$5:$A$5000="5811"))

[Glenn Kennedy]

There was a space in the formula that shouldn't have been there. use this...

Please Login or Register  to view this content.

[mmccra2858]

That works great.
Can you tell me how clean up a divide by zero error in this formula?

[:) Sixthsense :)]

Can you tell me how clean up a divide by zero error in this formula?

=Iferror(YourFormulaHere,"Error Masking Text/Value")

=IFERROR(SUMPRODUCT(--(Archive!K5:K5000="CAP"),--(MONTH(Archive!F5:F5000)=11)*(Archive!$A$5:$A$5000="5811")*Archive!N5:N5000)/SUMPRODUCT(--(Archive!K5:K5000="CAP"),--(MONTH(Archive!F5:F5000)=11)*(Archive!$A$5:$A$5000="5811")),0)

[mmccra2858]

Thanks for the help, I knew to use Iferror but I think the syntax was wrong.