Forum Discussion
Counting against merged and non-merged cells
First, for future reference, it's actually a lot more helpful if you upload the actual spreadsheet, rather than just an image.
Second, the solution (or "A solution") that works with the newest versions of Excel--which I hope you have--is this formula in Cell A1. No need to copy it down to cells, merged or otherwise.
=COUNTA(UNIQUE(C2:C15))
That said, you're generally going to be better off NOT merging cells as you've done here. In effect, you're doing manually something that might make it easier to visually differentiate, as a new Country enters the picture, but what happens if/when:
- Italy adds another item
- USA deletes a row
- etc.
If the formula I gave you doesn't work, come back and we'll give you a different way to do it that is less elegant but works..... but please do away with the merged cells first. And upload the spreadsheet itself.