Formula to Count Number of Rows that meet a condition in 1 column and another column

skachelek

Hi,

I am trying to write a formula to count the number of rows that meets the following:

• Looks at a column called "Project Approval" and finds rows that contain a value of "Approved"
• AND looks at another column called "Project Status" to exclude "Completed"

I am also creating this formula in a sheet that references the sheet that has the two above columns.

Any help on this? I have tried various COUNTIF and COUNTIFS formulas but thoroughly confusing myself at this point.

Thank you!

dojones

Try this:

=COUNTIFS([Project Approval]:[Project Approval], "Approved", [Project Status]:[Project Status], <>"Completed")

dojones

Try this:

=COUNTIFS([Project Approval]:[Project Approval], "Approved", [Project Status]:[Project Status], <>"Completed")

skachelek

Perfect! Worked, thank you so much.