I have details of meals ordered in the “Meal Order Sheet”. I wish to sum the number of Add-on orders in “Meal Order Sheet”!J: J in another sheet for items listed in the column “Meal Order Sheet”!I:I. I used SUMIFS, QUERRY formula, and ARRAYFORMULA and am not getting the desired results. The sample data is as follows

Sample “Meal Order Sheet”!Cx:Mx

1.

=sumifs('Meal Order Sheet'!J:J,'Meal Order Sheet'!I:I,I3, 'Meal Order Sheet'!C:C,$F$1,'Meal Order Sheet'!L:L,$B$2)

I am always getting a result “0” (Zero).

2. Using either of these

=QUERY('Meal Order Sheet'!A:L, "SELECT SUM(J) WHERE I = '"&I3&"' AND C = '"&$F$1&"' AND L = '"&$B$2&"'", 1)

=ARRAYFORMULA(QUERY('Meal Order Sheet'!A:L, "SELECT SUM(J) WHERE I = '"&I3&"' AND C = '"&$F$1&"' AND L = '"&$B$2&"'", 1))

I always get the header in cell ‘Meal Order Sheet’!J1, which is “No of Add-ons”.

3. Using formula

=QUERY('Meal Order Sheet'!A:L, "SELECT SUM(J) WHERE I = '"&I3&"' AND C = '"&$F$1&"' AND L = '"&$B$2&"'", 0)

I am always getting result “SUM”.

Kindly advise the correct formula that I should use