1. R

    Count unique on 1 column include rows per another column using SUMPRODUCT ...

    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...

Some videos you may like

This Week's Hot Topics