Just remember to enter it as an array. (Ctrl+Shift+Enter)
No need to array enter.
--
Biff
Microsoft Excel MVP
"Luke M" wrote in message
...
There is an extra parenthesis at the end. Other than that, that's the same
as
what I got. Just remember to enter it as an array. (Ctrl+Shift+Enter)
--
Best Regards,
Luke M
"Bernard Liengme" wrote:
=SUMPRODUCT((('M:\WORKBOOK1\SHEET1'!$A$7:$A$70="IN T")+('M:
\WORKBOOK1\SHEET1'!$A$7:$A$70="IT")+('M:WORKBOOK1\ SHEET1'$A$7:$A$70="MA")),'M:\WORKBOOK1\SHEET1'!"$A K$7:$AK$70))
UNTESTED
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"torooo" wrote in message
...
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.