Since creating this Named function a few weeks ago, I’ve been using it every single day. So I thought I should share it.
While dealing with spreadsheets, you probably run into scenarios where you wish you could quickly choose one row and know:
How many unique entries there are in this row.
How many times each entry shows up.
Ok, ok… real-life example: You export Leads data from Hubspot, 250 rows. You just wanna know how many of them are SQL / MQL, etc. If you’re new to this dataset, you might also be curious to know how many different lifecycle stages there are.

Introducing: CountEm

Assuming your lifecycle stage data is in column B. Just type =countem(B:B) and you’ll get:

Yeah, I could probably fine-tune this formula a bit, but it does what it says on the tin: It counts them.
And as I said, I’ve been using it so many times in the last few days that I thought it’s not fair not to share it.
So here it is. Hope you find it useful.



Omri Levy

Author Omri Levy

More posts by Omri Levy