View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Help for sumif / sumproduct

Actually, that should be the following. I had an extra column of data
in my spreadsheet.

Try =SUMPRODUCT(($A$4:$A$9=$A$1)*($B$4:$B$9=$B$1)*(C4: C9))

- John