Why is this happening?
 

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

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

Hi

why are you "SUMPRODUCT"ing Total Cost * by Selling Price ..anyway???

Total Cost MULTIPLIED by Selling Price will give you a very different answer
from Total Cost PLUS Mark Up.

If you'ld like to let us know what you're trying to achieve with this
formula maybe we can suggest a workable solution.

Cheers
JulieD



"retcgr" wrote in message
...

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