CODEWITHSUNDEEP
excel
Martin Dršata
Martin Dršata

Reputation: 3

Excel merged cell contains multiple values problem

I have encountered an excel spreadsheet, where some merged cells are. The problem is that when i sum over the cells, the value is higher then i can visually see in the cells.

For example: let's say i have merged cells A1:B1 into one and wrote a formula in that cell that gives the result 5 which i can visually see in the cell, but when i sum over the cell, the value is 6. Also upon unmerging the cell i can see formula in cell A1 and number 1 in cell B1.

Obviously, i can sum only over the A column but why is this happening? Has anyone encountered such a thing? I couldn't find anything about this.

Upvotes: 0

Views: 488

Answers (1)

Robert Hohnstein
Robert Hohnstein

Reputation: 1

4 years too late I'm sure but I too ran into this problem yesterday while trying to graph something in excel. I had a series of data that used a merged cells and in those cells the data displayed as the correct value however once graphed it displayed wildly different values and when I look in the select data pop up for the graph the series in question showed it was using twice as many "categories" (x axis points) as the rest of the series. In those categories I noticed old data that had existed before I merged the cells and changed the values. The fix I found was to unmerge all the cells. When I did it started displaying the old data that was no longer being displayed and I thought I had deleted. I deleted the values and made the series look right however I have yet to figure out why excel is trying graph the series as if the cells were not merged. Im still getting twice as many data points (categories) as I should.

Upvotes: 0

Related Questions