=SUMPRODUCT(--(A1:A4=1),(B1:B4)^2)

--

Jim Cone

Portland, Oregon USA

http://excelusergroup.org/media/
(Formats & Styles xl add-in: lists/removes unused styles & number formats)

"jeffrey"

wrote in message

...

I want to perform a sum of squares with conditions. I know there is a

SUMSQ function and a SUMIF function, but is there a SUMSQIF function?

I have a table like:

ColA ColB

1 3435

2 45345

2 230

1 9685

I want to sum the squares of ColB, if ColA=1

Jeff