1 variable => 1 equation type question
As answered
in your other similar post
, you have to previously create equations to sum your responses.
After ou will be able to display a message a message using EM or Javascript; I don't know how it is possible to sort (up or down) numeric results using EM except doing substractions (it's ok for 2 or 3 numbers) and that's why I've indicated you a js method (the only way i know to sort more numbers).
Re-using your example you need:
a) 3 questions to set your variables
MYNEWVAR_1 => {countif( 'AAA', D1, D2, D3, D4, D5, D6, D7, D8, D9, D10, D11, D12)}
MYNEWVAR_2 = {countif( 'BBB', D1, D2, D3, D4, D5, D6, D7, D8, D9, D10, D11, D12)}
MYNEWVAR_3 = {countif( 'CCC', D1, D2, D3, D4, D5, D6, D7, D8, D9, D10, D11, D12)}
b) 1 equation to compare the results and display your messages.
{if(MYNEWVAR_1 > (MYNEWVAR_2 + MYNEWVAR_3), 'hello world!', 'bye bye' )}