I'm trying to count unique occurrances of items in a particular column of a table using SUMPRODUCT. The formula that is working for me is SUMPRODUCT((IF(FREQUENCY(B1:B11,B1:B11)>0,1,0))). This works just fine!
My intent is to add criteria, incrementally, building the formula to...