4 rows: many, many columns
Row 3 =Total Cost - a manul input
Row 4 =Cost Per Item - a manual input
Row 5 = Mark Up (Cost Per Item *.05)
Row 6 = Selling Price or Cost Per Item + Markup
seems straightforward enough.

But if I SUMPRODUCT Total Cost * Selling Price I get a different answer
from when I Sum the Total Cost, Sum the Mark Up and Add them together.
I don't get it.

I thought I had a formula booboo, so I performed a "trace dependents" -
I got smething that looks like a little Excel Table in a one cell in the
Cost Per Item row.

Any ideas?


--
retcgr
------------------------------------------------------------------------
retcgr's Profile: http://www.excelforum.com/member.php...o&userid=16695
View this thread: http://www.excelforum.com/showthread...hreadid=319195