In Excel for web, I use certain functions like UNIQUE and SUMIF over large ranges. Often times these ranges contain blank values, and UNIQUE will output a
0, and SUMIF too. How can I filter these?
I've tried using the FILTER function, but it doesn't seem like that's meant for arrays.
With the following example I get the values that I want, followed by a long list of zeros. Is there any way I can prevent that?
=SUMIF(Transactions!$J$3:$J$1000, $A$2:$A$1000, Transactions!$F$3:$F$1000)