Pages tagged “countif”

2 pages in Cellwise.

1. Percent complete from a status column

   Count Done tasks and divide by all tasks, then label the project Done, In progress or Not started.

   project tracker countif

2. Rank values with COUNTIF, plus ties, 2nd largest and top name

   Rank a list with COUNTIF and handle ties, then pull the Nth largest value and the top name.

   rank countif large

All pages