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
Hi,
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