Is there any way to combine the SumSq function with SumIf? I have stuff like this:
I'm trying to sum the squares of just "1" for example. I could do it in another worksheet but it would be cooler if I could combine SUMSQ and SUMIF someway. Not sure if there is any good way to do it though.