As an aside, this version

=SUMPRODUCT(--(A1:A20=7000),--(B1:B20=12),C1:C20)

although longer is more efficient I am sure


--
HTH

Bob Phillips

"Gordon" wrote in message
...
Bob Phillips wrote:
=SUMPRODUCT(--(A1:A20&B1:B20="700012"),C1:C20)


I'd just found "sumproduct" but your version of it is MUCH neater. Thanks!