=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