Site icon ExcelNotes

How to Count Emails from the Same Domain

The COUNTIF function counts the number of cells that meet one criterion, such as the cells with a text string, the cells with a certain value, etc. The following formula is to help you get the count of email addresses from the same domain

Example: You are working on a dataset with the first name in column A, the last name in column B, and the email address in column C.

Formula 1: How many email addresses are "gmail.com"?

= COUNTIF(C2:C12, "*@gmail.com*")

Five email addresses are "gmail.com".

Formula 2: How many email addresses are "Gmail"?

= COUNTIF(C2:C12, "*@gmail*")

Six email addresses are "Gmail", and one is "gmail.ca".

Exit mobile version