"Tami C" wrote:
... The sumproduct doesn't work because the criteria
used in SUMIF points to selected cells and ...

=SUMIF('[databook.xls]Bogus Numbers'!$A$3:$B$10,A6,'[databook.xls]Bogus
Numbers'!$B$3:$B$10) Result = 60

A little late this response, but in case
the thread is still being tracked ...

Think there's a typo in your SUMIF above,
in the part: $A$3:$B$10
which should have read: $A$3:$A$10

Anyway, here's a lightly tested (working)
SUMPRODUCT translation
of the above (following what Dave P suggested earlier)

In say, B6:

=SUMPRODUCT(--('[databook.xls]Bogus Numbers'!$A$3:$A$10=A6),
'[databook.xls]Bogus Numbers'!$B$3:$B$10)

The formula can be copied down the col to return
correspondingly for other values in A7, A8, etc
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--