I have 3 columns of data in a worksheet called "data". the
information in this wksheet is organised as follows:

CC Nom Amount
KABC 4101 500
KABQ 5101 700
KABC 4102 450


Now, I would like to write an array formulae/sum product what would up
all the nominal codes in 4101-4107 series when the code KABC is typed
in cell a2. I have tried this, it wont capture the "41" range:
=SUMPRODUCT(--('[May 07.xls]Actuals'!$A$2:$A$20000=$a$2),--('[May
07.xls]Actuals'!$B$2:$B$20000=$B7),('[May 07.xls]Actuals'!$C$2:$C
$20000)). The fault with this formulae is that it cant group specific
codes and report the amount. Can anyone help please.

Many thanks,
Ola.