#### svtsilversnake

##### New Member

- Joined
- Dec 16, 2013

- Messages
- 13

the formula that is calculating the gross margin

=SUM(F4/(E4-100/100)*-1-F4)

this is the formula I use in column "Y"

=SUM(Z:Z)

this returns a value of $370,723.84

which is double the actually amount when I high light all My totals.

any Ideas?

This one has me pretty stumped because im reasonably familiar with excel and making formulas but this doesn't make sense.

Thanks a Bunch.