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
Bookmarks