Shred Dude

03-11-2011, 12:03 AM

I have a simple sumproduct formula as follows:

=SUMPRODUCT(--(INDEX(Contracts,,2)=M4)*IFERROR((INDEX(Contracts,,5)/28),0))

I'm attempting to match the value in cell M4 in the 2nd column of the Range "Contracts" and then sum up the value in column 5.

If i view the result in the Fx Formula Arguments window by clicking the Fx on the formula bar, I see the Formula Result I would expect given my data. On my sheet however, there is a different number being dislayed.

I can change the value in M4 to other valid values and the same occurs. The correct result shows in the Formula Result, but not on the sheet.

Anyone ever experienced this?

=SUMPRODUCT(--(INDEX(Contracts,,2)=M4)*IFERROR((INDEX(Contracts,,5)/28),0))

I'm attempting to match the value in cell M4 in the 2nd column of the Range "Contracts" and then sum up the value in column 5.

If i view the result in the Fx Formula Arguments window by clicking the Fx on the formula bar, I see the Formula Result I would expect given my data. On my sheet however, there is a different number being dislayed.

I can change the value in M4 to other valid values and the same occurs. The correct result shows in the Formula Result, but not on the sheet.

Anyone ever experienced this?