-
Re: Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error
I figured it out thanks. =AVG(COLLECT({Case Consultation Tracker Range 99}, {Case Consultation Tracker Range 99}, >=100000 < 500000, {Case Consultation Tracker 98}, >=DATE(2024, 1, 1)))1 ·