"jeffrey" wrote:
is there a SUMSQIF function?
[....]
I want to sum the squares of ColB, if ColA=1
AFAIK, there is none. None found using a Google search (hint!). But
whenever you ask a question like that, you need to specify the Excel
version(s) you are asking about.
Anyway, the alternative is the following __array_formula__[*]:
=SUMSQ(IF(A1:A1000=1,B1:B1000))
[*] Enter an array formula by pressing ctrl+shift+Enter instead of Enter.
Excel will display an array formula surrounded by curly braces in the
Formula Bar, i.e. {=formula}. You cannot type the curly braces yourself.
If you make a mistake, select the cell, press F2 and edit, then press
ctrl+shift+Enter.