jeffrey said:

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.