# Problem summing an entire column

#### svtsilversnake

##### New Member
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.

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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?

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

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

Do you have any subtotals in Column Z?

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

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

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)?

Replies
2
Views
293
Replies
7
Views
227
Replies
5
Views
229
Replies
10
Views
284
Replies
5
Views
255

1,203,521
Messages
6,055,883
Members
444,830
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back