Another Ver Calc Formula SUM gives an answer #VALUE!

asked 2015-06-10 02:19:50 +0100

RCB37 gravatar image

updated 2015-09-27 18:32:13 +0100

Alex Kemp gravatar image

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 . It gives #VALUE! instead. This resembles a previous question involving a SUM with curly brackets.

Any suggestions? Thanks,


edit retag flag offensive close merge delete


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.

Lupp gravatar imageLupp ( 2015-06-10 07:09:18 +0100 )edit