in SUM condition needs to check for a name and its variation. "*" ?

[nahaku]

=SUMIFS(Table4[PCS],Table4[staff],IFS(Table4[staff]=$BP57,$BP57,Table4[staff]="GRS-"&$BP57,"GRS-"&$BP57),Table4[data_source],"GRS")
with this function I will get long array with same numbers, not one number as SUM. It seems like it is just suming all numbers if it is the condition True, not as one :{

I have a column of names where the names are like ABC54646 and sometime it is with GRS-ABC54646, Normaly I would use power query to get rid of it, but I do not want to add aditional tabels as this file will have too many of them already because it will be monthly summary.

Firstly I wanted use just "*" before Cell reference but It then cant look up somethink like ....ABC54646 it would look up "*$BP7" and of course it fails....
Any suggestions?

 

[nahaku]

Well I found on internet solution just to use simple + :P
=SUMIFS(Table4[PCS],Table4[staff],"GRS-"&$BP54,Table4[data_source],"GRS")+SUMIFS(Table4[PCS],Table4[staff],$BP54,Table4[data_source],"GRS")
I will go with this

 

[Peter_SSs]

Well I found on internet solution just to use simple + :P
=SUMIFS(Table4[PCS],Table4[staff],"GRS-"&$BP54,Table4[data_source],"GRS")+SUMIFS(Table4[PCS],Table4[staff],$BP54,Table4[data_source],"GRS")
I will go with this

If you are happy that is fine but I don't know what $BP54 is, and it looks a more complicated approach than what I suggested.

 

[nahaku]

If you are happy that is fine but I don't know what $BP54 is, and it looks a more complicated approach than what I suggested.

"BP" is instead of "i" cell refference

 

[Peter_SSs]

"BP" is instead of "i" cell refference

So, did you try my suggestion as well? If it does what you want, it is considerably simpler.