I've been staring at this and can't figure out where the error is. It's saying the formula is invalid, could someone take a look and see if the parentheses are all making sense?
thank you!
=IFERROR("SUMIF(B$3:B3,GRAPH!AF$3,(((OPPERA!R$3:R3)*13)+((OPPERA!O$3:O3+OPPERA!S$3:S3-OPPERA!T$3:T3)*3)-((OPPERA!U$3:U3)*2)))/(SUMIF(B$3:B3,GRAPH!AF$3,OPPERA!N$3:N3))", 0)
thank you!
=IFERROR("SUMIF(B$3:B3,GRAPH!AF$3,(((OPPERA!R$3:R3)*13)+((OPPERA!O$3:O3+OPPERA!S$3:S3-OPPERA!T$3:T3)*3)-((OPPERA!U$3:U3)*2)))/(SUMIF(B$3:B3,GRAPH!AF$3,OPPERA!N$3:N3))", 0)