Count a drop down selection in entire column

R Scov

Hello please see attached photo. I am wondering how I can count lets say "90% CD" for the entire column. Each of the choices come from a drop down menu. So essentially I would like to be able to count how many "90% CD" and "70% CD" etc. Thank you!

Tomasz Giba

Hi @R Scov

Try this formula:

=COUNTIF([Project Design Stage]:[Project Design Stage], "75% PD")

=COUNTIF([Project Design Stage]:[Project Design Stage], "100% SD")

etc.

Tomasz Giba

Hi @R Scov

Try this formula:

=COUNTIF([Project Design Stage]:[Project Design Stage], "75% PD")

=COUNTIF([Project Design Stage]:[Project Design Stage], "100% SD")

etc.

R Scov

Amazing thank you! Worked brilliantly!