=SUMPRODUCT(--('[Rates.xls]Sheet1'!$S$3:$S$261=$E8)1,--('[Rates.xls]Sheet1'!$K$3:$K$261=$F8)1)

Perhaps try it as:
=SUMPRODUCT(([Rates.xls]Sheet1!$S$3:$S$261=$E8)*([Rates.xls]Sheet1!$K$3:$K$261=$F8))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RS" wrote:
...Since I've never used SUMPRODUCT before, I looked at the Excel Help (no
help there) and the forums here to try and fix my equation. What I came up
with is the following:
=SUMPRODUCT(--('[Rates.xls]Sheet1'!$S$3:$S$261=$E8)1,--('[Rates.xls]Sheet1'!$K$3:$K$261=$F8)1)

However, I'm doing something wrong, because it's returning 0 for something
that, with the other formula, gave a result of TRUE because there was 1
possible value for the 2 matching criteria. What am I doing wrong?