Martin,

take a look here for an in-depth explanation of SUMPRODUCT:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps.

Pete

On Aug 14, 4:18*pm, wrote:

Hi Pub,

It's taken me a couple of weeks to get round to implementing this, but
just wanted to say a belated thanks for your suggestion, which I've
got to work fine. Thanks for putting me onto the sumproduct function,
which is ideal.

One observation: the logical arguments don't work very well. For
example the ('Money data'!$B$1:$B$29=B$4) bit produces 'FALSE' or
'TRUE' rather then 0 or 1, which screws the whole thing up. I had to
coerce excel into giving me 1 or 0 by doing (0+('Money data'!$B$1:$B
$29=B$4)) which seems to work.

Also, I had to replace the asterisk characters with commas.

Frankly I'm out on a limb here, knowing very little about Excel apart
from absolute basics, so if the above is rubbish do please tell me,
but it seems to work.

Cheers!

Martin