I am having issues with count/sum with my merged cells. Sometimes the merged cells are counting the contents as 1 and sometimes as multiple cells. I would like for excel to count the merged cells as 1. For example, I have cells c24-c25 merged into one cell with "1" in the cell. On the bottom right hand corner of the excel spreadsheet, it is stating that the selected cells has count:2 and sum: 2 but I would like for it sum as 1 and count as 1.
I also have cells c10-c13 merged with "1" in the cell. This time excel is reading it as count of 1 and sum of 1. Does anyone know why excel reads these 2 merged cells differently and how can I get it to read as one?
Merged Cell Example.xlsx
Any help is greatly appreciated!
Thanks,
Linda
Bookmarks