sumproduct!!!

[Frank Kabel]

Hi
what is the exact formula you have used?

--
Regards
Frank Kabel
Frankfurt, Germany

Hello,

I have approximately the same example as Nowfal below but my data are on
different excel files. So when I tried the function you gave below I always
get #N/A although the file and sheet names are correct.

Any idea why?

Thanking you in advance.

 

[Guest]

Hello,

This is the formula that I used

=SUMPRODUCT(--('P:\Gv\Data\xls\[040923-2HR-ProfileAnalysis.xls]02-Profile'!$D$100:$D$212="Ba"),--('P:\Gv\Data\xls\[040923-2HR-ProfileAnalysis.xls]02-Profile'!$J$100:$J$212="S"),'P:\Gv\Data\xls\[040923-2HR-ProfileAnalysis.xls]02-Profile'!$B$100:$B$212)

Thank you for your assistance.

 

[Dave Peterson]

Your formula worked ok for me.

I think you should look at your data and see if you have any errors (like #n/a)
in: D100:d212, J100:J212 and B100:b212.

Hello,

This is the formula that I used

=SUMPRODUCT(--('P:\Gv\Data\xls\[040923-2HR-ProfileAnalysis.xls]02-Profile'!$D$100:$D$212="Ba"),--('P:\Gv\Data\xls\[040923-2HR-ProfileAnalysis.xls]02-Profile'!$J$100:$J$212="S"),'P:\Gv\Data\xls\[040923-2HR-ProfileAnalysis.xls]02-Profile'!$B$100:$B$212)

Thank you for your assistance.