Help! My SUMIF formula isn't working as expected and I'm not sure why.
These versions don't work:
=SUMIF(Table16[EEs covering the course or programme (unique identifier)],"*smi3*",Table16[PG ONLY
TOTAL (higher + lower rates / no. EEs)])
These versions don't work:
- =SUMIF(Table16[EEs covering the course or programme (unique identifier)],"*[@[Unique Identifier]]*",Table16[PG ONLY
TOTAL (higher + lower rates / no. EEs)]) - =SUMIF(Table16[EEs covering the course or programme (unique identifier)],"*"[@[Unique Identifier]]"*",Table16[PG ONLY
TOTAL (higher + lower rates / no. EEs)]) - =SUMIF(Table16[EEs covering the course or programme (unique identifier)],"*A2*",Table16[PG ONLY
TOTAL (higher + lower rates / no. EEs)]) - =SUMIF(Table16[EEs covering the course or programme (unique identifier)],"*"A2"*",Table16[PG ONLY
TOTAL (higher + lower rates / no. EEs)])
=SUMIF(Table16[EEs covering the course or programme (unique identifier)],"*smi3*",Table16[PG ONLY
TOTAL (higher + lower rates / no. EEs)])