I am trying to add the value of 2 functions in a Google spreadsheet. The function itself is to add the values that are only in the color that is passed as a reference. The formula is this.
sumColoredCells(E4:E34;D36)
My intention is to add the value of that formula, with the value of another equal but selecting other columns. This is what I have tried.
=SUM(sumColoredCells(E4:E34;D36);sumColoredCells(G4:G34;D36))
I get #ERROR! .
I hope someone can help me out with this sum. Thank you very much!