Thread
:
Help for sumif / sumproduct
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
John Michl
Posts: n/a
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
Reply With Quote