View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_4_] barry houdini[_4_] is offline
external usenet poster
 
Posts: 57
Default Sum with a Twist Q

Hello Seanie,

You can use SUMIF like this

=SUM(SUMIF(J10:J22,{333333,444444},H10:H22))