Max if

Samuel Dowdy Jr.

=MAX([Month - Count]:[Month - Count], IF([Month Closed]:[Month Closed], 1))

I know Im way off on this formulas, but what I am trying to do is reflect the month that is currently closed. Month Closed is a checkbox. Im trying to collect the most recent or max month count if the month is closed is checked.

Leibel S

@Samuel Dowdy Jr.

=MAX(COLLECT([Month - Count]:[Month - Count], [Month Closed]:[Month Closed], @cell=1))

Leibel S

@Samuel Dowdy Jr.

=MAX(COLLECT([Month - Count]:[Month - Count], [Month Closed]:[Month Closed], @cell=1))