Why is this happening?

[retcgr]

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 answe
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 th
Cost Per Item row.

Any ideas

 

[Frank Kabel]

Hi
could you post your exact two formulas

 

[JulieD]

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