"Harlan Grove" wrote
...Even using the OP's data,...
your wonderful formula returns 2 even though only the second row
matches the (A1:A5="Jan")*(C1:C5=2) criteria.

Yup, you're right. Thanks for jumping in.

Can you figure out why?

Of course I can :-) It is the extra element (the count of values superior of the max interval).

Did you bother to test? Rhetorical - obviously not.

I did, but with my own randomly generated data based on the OP's pattern. It so happened that in my sample the max value was
preceded by a 0 in the second argument something like this:

FREQUENCY({1;2;3;3;1},{0;2;0;3;0}) - {0;3;0;2;0;0}

....so when it worked after a couple of random changes I wrongly concluded that the formula was good.

Did you bother to consider this possibility before firing out your "verdict"? Rhetorical - obviously not, but thanks anyway ;-)

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/pr...A-9E6C73C09A36