MINIFS Formula Not Working or Not understanding

MINIFS FORMULA. I have a subtable that I need to get the minimum price that is also active so the formula i had that doesnt seem to work is MINIFS(data i need the minimum table head, data where the active inactive status is held table head, ‘Active’). The formula seems to never populate. I could greatly use some help with this


Originally, the error comes from the spelling error in the formulas of the referenced field. Then, you’ve changed the MINIFS() again which I’ve replied as below:


1 Like