Multiple Criteria Formula - Metric Sheet

JNash

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

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

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

Nic Larsen

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.

Nic Larsen

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

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

JNash

When I do that:

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

I get an #Unparseable. Is that because there is a "/" in the reference?

JNash

That was the problem! When I change the column title it worked! Thank you :)

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

Nic Larsen

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.