In the attached example I have a simple data table (Table2) with three data columns: Color, Shape and Weight. I can make a count of the occurrence of Weight in defined Bins (in Table 5) using the array formula FREQUENCY

{=FREQUENCY(Table2[Weight],Table5[Bin])}

and can filter the count successfully in the array formula on the basic of one criteria (in G2):

{=FREQUENCY(IF(Table2[Color]=$G$2,Table2[Weight]),Table5[Bin])}

But if I try to filter on the basis of two criteria by using an AND statement in the FREQUENCY formula, it doesn't work:

{=FREQUENCY(IF(AND(Table2[Color]=$G$2,Table2[Shape]=$G$3),Table2[Weight]),Table5[Bin])}

Am I trying to do the impossible or do I need a particular syntax?


Thanks in advance for any assistance

example.xlsx