Portfolio Metrics Formula
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! 😖
Help Article Resources
Check out the Formula Handbook template!