Problem summing an entire column

[svtsilversnake]

I have a worksheet that I use for work that calculates my gm based on our total cost and rate we quoted material at. When I highlight the column that all of this data is in I get a number that is twice that of what is actually in the column. the location that this sum is generated is in another cell so I know that's not the issue. I have also go down the entire work sheet in that column looking for a random value but cant find anything. the only thing I can figure is that my formula is for some reason causing an issue

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.

 

[AlphaFrog]

Are any rows hidden or filtered? The SUM function will sum all values in column Z regardless of filtered\hidden rows.

Is the SUM result exactly double?

 

[svtsilversnake]

yes its exactly double. I cannot find any hidden cells or rows either

 

[Rick Rothstein]

yes its exactly double. I cannot find any hidden cells or rows either

Do you have any subtotals in Column Z?

 

[svtsilversnake]

No sir, I look all the way to the bottom and see nothing. No hidden rows or columns. Even when I auto filter the column and look at every total there the all add up to the correct ammount, not the 370,723.84

 

[svtsilversnake]

it is the only column on this sheet that is doing this too.

 

[Rick Rothstein]

No sir, I look all the way to the bottom and see nothing. No hidden rows or columns. Even when I auto filter the column and look at every total there the all add up to the correct ammount, not the 370,723.84

You said "every total" above... you have totals (more than one) shown in the same column as the numbers they are totaling? If so, that is what I meant by sub-totals (your ultimate goal is grand total of what is in that column, correct)... what formula are you using for those totals (show us just one of them)?