View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
torooo torooo is offline
external usenet poster
 
Posts: 12
Default Replace SUMIF with SUMPRODUCT

I would like to replace the formula below with SUMPRODUCT:

=SUM(IF(('M:\WORKBOOK1\SHEET1'!$A$7:$A$70="INT")+( 'M:
\WORKBOOK1\SHEET1'!$A$7:$A$70="IT")+('M:WORKBOOK1\ SHEET1'$A$7:$A
$70="MA"),'M:\WORKBOOK1\SHEET1'!"$AK$7:$AK$70))


Thanks in advance for your assitance.