Another Ver 4.3.7.2 Calc Formula SUM gives an answer #VALUE!

[RCB37]

Under Win 7 64 bit OS, the function

{=SUM((LEFT(A16:A148,12)=“Grand Total:”)*(D16:D148))}

Ran under previous versions of CALC but does not work in version 4.3.7.2 . It gives #VALUE! instead.
This resembles a previous question involving a SUM with curly brackets.

Any suggestions? Thanks,

R

[Lupp]

1. I didn’t test with V4.3.7, but the formula is working in V4.4.3.

2. Using =SUMPRODUCT(LEFT(A16:A148;12)=“Grand Total:”;D16:D148) you won’t need to explicitly make it an array formula.