Hello Excel Wizards,
In this scenario (see attached and below)the user will select his basic ice cream type and then his requested toppings. Based on those selections he can see which of his selected items is contributing the maximum calorie content. My formula '=IF(F4=1,MAXIFS($B$10:$B$180,$C$10:$C$180,1),"") is still returning a max calorie value even though there are "n/a" items selected. I am not familiar enough with array formulas to understand why the MAXIFS formula isn't returning an error when there is a text entry in the array. I thought about trying to multiply each value by 1 to determine whether a value is text or a number but I'm just not sure how to do this with the selected items only in an array. Thanks for your help!
Ice Cream Store.png
Marvelous (wishful thinking)
Bookmarks