I've used Array Formula to calculate the total price for an order and I have a manual column next to it to note what has been paid. When I come to do a comparison of the two though, Google sheets appears unable to SUM
the column created by Array Formula but has no problem with the manually created ones.
Is there a way around this?
I've made a dummy sheet illustrating the issue here https://docs.google.com/spreadsheets/d/1XZr3Kj2jq2jxjhU6nCfthdu9TBdxJKzdYW0uMpwOO7w/edit?usp=sharing
=ARRAYFORMULA(IF((LEN(A1:A)+LEN(B1:B)),IF(ROW(P:P)=1,"Cost",FIXED(A:A+B:B,2)),))
- i.stack.imgur.com/uKqVd.png