hi Don,

=SUMPRODUCT((LEFT(A1:A35000,3)<"HD:")*(C1:C35000) )

isabelle

Le 2014-03-10 21:16, Don Wiss a écrit :
It has been years since I've done an array formula. And I was never that
good with them. I would think that this should work:

{=SUM((LEFT(A1:A35000,3)<"HD:")*(C1:C35000))}

It doesn't. It gets #VALUE!

Don. www.donwiss.com (e-mail link at home page bottom).