SUMIF formula not working

[efay]

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)],"*[@[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)])

This version does work, but I don't want to have to enter specific strings into every cell:
=SUMIF(Table16[EEs covering the course or programme (unique identifier)],"*smi3*",Table16[PG ONLY
TOTAL (higher + lower rates / no. EEs)])

 

[Fluff]

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[efay]

Hiya, I don't want to install anything on my computer (don't think I have the permissions) but here's some test data from the EEs data:

5,6,4

smi3, 6, 3, test

smi3, 5

Here's some test data from the PG TOTAL ONLY column:

£0.00​

£189.13​

£323.75​

 

[Fluff]

That data makes no sense in relation to your formulae & so makes it difficult to help.