hi,


i'm have a table with information about specific meals:

sept 1      Chris     Burger

Sept 2     Jane     Pizza

Sept 2     Chris     Pizza

Sept 3    Jane      Chicken

Sept 4    Jane      Burger

Sept 5    Chris     Burger

etc. . .

What I want to be able to do is count the number of instances that meet two criteria (person and meal), for example how many times did Chris eat a Burger, and I want to do this for every combination of people and meal.

What I would do in Excel is make a table with names on one axis and meals on the other and use the sumproduct command:

=sumproduct((Namerange="Name")*(Mealrange="Meal"))

This form of sumproduct doesn't seem to work in Zoho sheets.  I tried doing the same in google spreadsheets, where this also doesn't work but found another way using the Count and Filter commands.

Anyone know how to do this in Zoho?  thanks


Chris