MODEIFS and Text Mode

[B1313]

Hello,

I am trying to accomplish a simple goal, depending on some conditions calculate the mode of some text entries. The problems are multiple. For one, I can't seem to get a MODEIFS function or Mode combined with a bunch of if/and/or statements to work correctly whilst searching for the mode of text. Here is my working formula for mode via ALL orders, I want to be able to add if options to filter the mode (eg if date = TODAY() the calculate the mode of ALL orders that were processed TODAY ONLY). Ideas? Would it be simpler to just make a MODEIFS VBA function? If so, can someone provide it?

Here is my formula (array formula) to at least calculate the text mode, but my if statements version does not work on anything that filters dates (eg IF(Orders!$C$6:$C$993 = TODAY(), MODE_STUFF, ...)):

=INDEX(INDIRECT(ADDRESS(6, 7, 1, 1, "Orders") & ":" & ADDRESS((MATCH(TRUE, INDEX(ISBLANK(Orders!$G$6:$G$993), 0, 0), 0) + 4), 7, 1, 1)), MODE(MATCH(INDIRECT(ADDRESS(6, 7, 1, 1, "Orders") & ":" & ADDRESS((MATCH(TRUE, INDEX(ISBLANK(Orders!$G$6:$G$993), 0, 0), 0) + 4), 7, 1, 1)), INDIRECT(ADDRESS(6, 7, 1, 1, "Orders") & ":" & ADDRESS((MATCH(TRUE, INDEX(ISBLANK(Orders!$G$6:$G$993), 0, 0), 0) + 4), 7, 1, 1)), 0)))

Here is a sample of the Orders spreadsheet:

Thanks for any help!