Google-sheets – Unable to SUM column calculated by Array Formula

formulasgoogle sheetsgoogle-sheets-arrayformula

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

Best Answer

  • instead of SUM use SUMPRODUCT

    =SUMPRODUCT(C:C)

    0

Related Topic