How to Count Emails from the Same Domain

The COUNTIF function is to count 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: To count the number of email addresses that are from "gmail.com"

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

There are five email addresses that are "gmail.com".

Formula 2: To count the number of email addresses that are from "Gmail"

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

There are six email addresses that are "Gmail", and one of them is "gmail.ca".

Leave a Reply