COUNTIF Archives | OXEN Technology

Tech Tip

Counting in Excel with COUNTIF

Maybe you have a list in Excel and you want to know the number of times repeating items appear. Say you have a list of contacts with their company names, and you want to know how many times a company appears (which is the number of contacts from that company on your list). There's an Excel formula for that, called COUNTIF! Create a Legend First, you need a list of unique company names only to create a "legend". You can get this by copying the Company column and pasting it into another column. Then select the new column and go…
OXEN Technology
May 29, 2017