Forum Discussion
Brian Brislenn
Mar 02, 2018Copper Contributor
MAX/IF and MAXIFS help
Hi!
I've been using a MAX/IF array function in some of my sheets. Recently I read about using MAXIFS instead, but I can't get it to return the same result as my array. I'm not sure what I'm doing w...
Detlef_Lewin
Mar 03, 2018Silver Contributor
Brian Brislenn wrote:
Column K in the other book
Using MAXIFS() requires the source workbook(s) to be open.