View Single Post
  #3   Report Post  
Old July 21st 11, 11:52 PM posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2008
Posts: 1,549
Default Sum of squares if condition

Jim Cone
Portland, Oregon USA
(Formats & Styles xl add-in: lists/removes unused styles & number formats)

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