MINIFS Formula Not Working or Not understanding


#1

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


#2

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:

%E5%9C%96%E7%89%87