On Mon, 10 Mar 2014 21:36:29 -0400, isabelle wrote:
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!
=SUMPRODUCT((LEFT(A1:A35000,3)<"HD:")*(C1:C35000 ))
Nope.
I think the problem has to do with many of the cells in C1:C35000 are
non-numeric. I tried this:
{=SUM(AND(LEFT(A1:A35000,3)<"HD:",ISNUMBER(C1:C35 000))*C1:C35000)}
And still n.g.
Don.
www.donwiss.com (e-mail link at home page bottom).