#NO MATCH error on a Sheet Summary Formula
I'm guessing the problem is because the field I'm referencing is a formula and not a value, but would appreciate suggestions on how to handle this.
I want a sheet summary formula to return how many Variances exist for each VarianceCategory, so I can use this information in a report.
I've listed the formulas that I'm attempting, but they return #NO MATCH.
Help Article Resources
Check out the Formula Handbook template!