And might be safer, too.
If the OP had something like this,
Account Dept
7000 12
70001 2
7 00012
the original formula might yield incorrect results.
Bob Phillips wrote:
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!
--
Dave Peterson
|