View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeffrey jeffrey is offline
external usenet poster
 
Posts: 8
Default Sum of squares if condition

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