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".
