sumproduct!!!

F

Frank Kabel

Hi
what is the exact formula you have used?

--
Regards
Frank Kabel
Frankfurt, Germany

Fad said:
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.
Click to expand...
 
F

Fad

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.
 
D

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.
Click to expand...
 
Top