You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
I still refuse to use Xlookup, Index double match all the way.
Also the way excel does the count\average\min\max if(s) is weird and slightly annoying.
for a single criteria, it is criteria range, criteria, sum range
for multiple criteria it is sum range, criteria range 1, criteria 1, criteria range 2, criteria 2 etc.
But you can use sumifs with a single criteria, so countif is superflous, which is guess why there is no Maxif but there is a maxifs.
Sam_w
@Chalfie
https://www.powerusersoftwares.com/post/xlookup-just-killed-vlookup-everything-to-know-about-this-major-new-excel-function