How to create a MODEIF()

[zantaff]

How would I get the Mode of a certain set of items within a column defined by another set of items within another column?

I'm trying to get the Mode of Int.SF based off the Room Category. (See pictures)
Data is in one worksheet and the summary is in another.

I understand how SUMIF works, but that doesn't seem to work the same with MODE.

Any ideas or suggestions would be great!

 

[deanst]

Hi,

You could try this. Enter as array formula (Ctrl-Shift-Enter).

=MODE(IF(Coffee_Rooms!M:M=A8, Coffee_Rooms!C:C))

Dean.