Please see the attached Excel file or screenshot of the problem.
testing.png
testing.xlsx
I want the formula to only count Group 1 entries, excluding Group 2's.
Code:
{=IF(Table1[Group]=1,COUNTIFS(Table1[Score],">="&0,Table1[Score],"<="&49))}
' return 4 (should be 2)
The formula did not get rid of Group 2; instead it counted all entries without sticking to the criterion "only Group 1"
Any help is appreciated.
I've also attached the Excel file.