Distinct CountIFS Statement

I need a little assistance...

I was able to get the formula to partially work using =count(distinct but, it was not taking the name cell into account and returned the same number in each row.

I need a distinct count of PrAbv based on P Name.

I got "#inccorect argument" when I changed count to countifs. I'm sure it's something simple I'm missing here.

=COUNTIFS(DISTINCT({Full_Name}, @cell = [P Name]@row, {PrAbv}, @cell = "B")) + COUNTIFS(DISTINCT({Full_Name}, @cell = [P Name]@row, {PrAbv}, @cell = "U")) + COUNTIFS(DISTINCT({Full_Name}, @cell = [P Name]@row, {PrAbv}, @cell = "A")) + COUNTIFS(DISTINCT({Full_Name}, @cell = [P Name]@row, {PrAbv}, @cell = "C")) + COUNTIFS(DISTINCT({Full_Name}, @cell = [P Name]@row, {PrAbv}, @cell = "P"))

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!