Hi
could you post your exact two formulas

--
Regards
Frank Kabel
Frankfurt, Germany

"retcgr" schrieb im Newsbeitrag
...

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