MODE fx in array using multiple criteria
 

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.

MODE fx in array using multiple criteria
 

Jon,

Enter using Ctrl-Shift-Enter:

=MODE(IF(Job=$A6,IF(Date=$A$1,IF(Date<=$A$2,Diame ter))))

Just continue with additional nested IFs to add additional criteria.

HTH,
Bernie
MS Excel MVP


"Jon Young" wrote in message
...
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.

MODE fx in array using multiple criteria
 

Worked! Thank you.

"Bernie Deitrick" wrote:

Jon,

Enter using Ctrl-Shift-Enter:

=MODE(IF(Job=$A6,IF(Date=$A$1,IF(Date<=$A$2,Diame ter))))

Just continue with additional nested IFs to add additional criteria.

HTH,
Bernie
MS Excel MVP


"Jon Young" wrote in message
...
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.

MODE fx in array using multiple criteria
 

Worked!

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

Thank you.

You're welcome. And thanks for the feedback.

Bernie

MODE fx in array using multiple criteria
 

Worked!

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

LOL

Rick