Excel function countif

Copper Contributor


I am trying to have a function that does the following:

When the values in column A are Axis 01 ( the axis can change so it will need to be able to change ), I want to know the number of uniques goals in column B ( the goals can be there twice, so I don't want to know how the total of cells, but the total of unique goals)

1 Reply



You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

count goals.JPG