Counting rows with multiple drop-down options

Colin Entrekin

Hello,

 

I would like to count all the rows on a sheet that meets certain criteria.  The sheet has a column [Project Status] with the following drop down items:

 

Tentative

Confirmed

In Process

Delayed

On Hold

Punch List

Completed

Cancelled

RMA Processing

 

I would like to get a total count of all the rows that have open projects, which would be one of the these statuses:

 

Tentative

Confirmed

In Process

Delayed

On Hold

Punch List

 

Please advise on how to make this formula work.  Thanks!

Brett Evans

Try this countif formula...

 

=CountIF([Project Status]:Project Staus],"Tentative") + CountIF([Project Status]:Project Staus],"Confirmed") + CountIF([Project Status]:Project Staus],"In Process")

+ CountIF([Project Status]:Project Staus],"Delayed" )+  CountIF([Project Status]:Project Staus],"On Hold") + CountIF([Project Status]:Project Staus],"Punch List" )