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.
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.
I get #ERROR! .
I hope someone can help me out with this sum. Thank you very much!