Thanks all, it works - - - but for the life of me I don't know why. It seems
like this evaluates to
=SUMPRODUCT(--(LEFT(A1:404),3)=$C$1)*(B1:4))).
But who am I to argue with success!!
Dan
"Ron Coderre" wrote in message
...
I swear I pasted in the formula then my PC Hiccuped!
Don't just hate computers???? Kidding (sheesh)
Anyway, try this:
=SUMPRODUCT(--(LEFT(A1:INDIRECT("A"&COUNTA(A:A)),3)=$C$1)*(B1:IN DIRECT("B"&COUNTA(A:A))))
Does that help?
--
Regards,
Ron
|