Portfolio Metrics Formula

KGUNSOLUS

Hi everyone,

I'm trying to calculate from two different columns on a portfolio summary and can't quite figure out the correct formula. I've gone through and tried many of the suggestions from here without any luck.

What I'm trying to accomplish: Count how many (blue) items are in "Health" column, but only if "Key Contact" column contains a specific name.

Please help! 😖

Paul Newcome

You would need a COUNTIFS.

=COUNTIFS({Health Column}, @cell = "Blue", {Contact Column}, @cell = "Specific Name")

Paul Newcome

You would need a COUNTIFS.

=COUNTIFS({Health Column}, @cell = "Blue", {Contact Column}, @cell = "Specific Name")

KGUNSOLUS

You're the best! Thanks Paul :)

Paul Newcome

Happy to help. 👍️