Multiple Criteria Formula - Metric Sheet

Question

I am looking for a formula to calculate the number of APPROVED projects with Technology Impact. I am able to get the number of all projects with technology impact, but cannot figure out the second part of the formula to only include APPROVED projects.

Current formula which includes information from the Technology Impacted column: =COUNTIF({Tech Impacted}, "<>NA")

Need additional help with the Approved column to only include projects "Approved".

This is the sheet data is being pulled from into the Metric Sheet. Thank you for any help.

Nic Larsen · Accepted Answer

Try changing to Countifs, and update the name of the approved range column:

=COUNTIFS({Tech Impacted}, <> "NA", {Approved Range}, "Approved")

Nic Larsen · Accepted Answer

It shouldn't as long as your cross-sheet range matches. I do see an extra closing parathesis in your formula that will cause issues:

{Approved/Declined}), "Approved")

That bold one is closing off the formula too soon.

But I see it's been removed when you revised it again.