MODE fx in array using multiple criteria

[Jon Young]

I can get SUM, MAX and MIN functions to work in arrays with multiple criteria
like this:

{=MAX(Diameter*(Job=$A6)*(Date>=$A$1)*(Date<=$A$2))}

But, from the example above, I now need to use MODE instead of MAX to return
the most frequently used Diameter within the data subset that meets these
same, multiple criteria. I just get 0.

Thanks in advance for helping.

 

[Bernie Deitrick]

Jon,

Enter using Ctrl-Shift-Enter:

=MODE(IF(Job=$A6,IF(Date>=$A$1,IF(Date<=$A$2,Diameter))))

Just continue with additional nested IFs to add additional criteria.

HTH,
Bernie
MS Excel MVP

 

[Jon Young]

Worked! Thank you.

Jon,

Enter using Ctrl-Shift-Enter:

=MODE(IF(Job=$A6,IF(Date>=$A$1,IF(Date<=$A$2,Diameter))))

Just continue with additional nested IFs to add additional criteria.

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

Worked!

Why does everybody sound so surprised when my suggestions work? ;-)

Thank you.

You're welcome. And thanks for the feedback.

Bernie

 

[Rick Rothstein \(MVP - VB\)]

Worked!

Why does everybody sound so surprised when my suggestions work? ;-)

LOL

Rick