Count of Occurences based on multiple criteria

I am looking to design a report that will self-update once food is selected from dropdown menus. I am attaching a sample of my report. I have tried the sumproduct and countif formulas but to no avail. Basically, I want a count of how much times a specific region has had different food orders. I have attached the data I have in sheet 1. In sheet 2 is the report that I want to set up to sum the # of times each of the foods are input (broken out by region).

I know I can run a pivot table but I want this to be a "live" report that will update automatically as someone enters a new food.

Any help would be much appreciated! Thank you so much

Countifs will work but you will have to do a seperate one for each of the 8 food columns, and sum them.

As rhl06 has it ^^ but instead in your formula, replace each of the instances of Data!$A$2:$A$9 with Data!$A:$A (for example) so it reads the whole column, therefore automatically updating when a new row is added.

Originally Posted by Dan_SJ

As rhl06 has it ^^ but instead in your formula, replace each of the instances of Data!$A$2:$A$9 with Data!$A:$A (for example) so it reads the whole column, therefore automatically updating when a new row is added.

Yep. Dan is right. The attached has a 60,000 row cap alternative "fix".

=+SUMPRODUCT((Data!$A:$A = Report!B$3)* (Data!$D:$K = Report!$A4))

will do same job but takes a lot of CPU power for all column

see attached

Thank you ALL for your excellent input. This worked perfectly and you all saved me HOURS of work and frustration!