COUNTA, Concatenate and SUMIF

[El Gallo]

Hello,

I'd like to concatenate values from two columns if they match the criteria from another sheet. Here's what I've come up with so far but I just can't get it give me the correct values:

=IF(COUNTA(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$C$2:$C$250)=1),CONCATENATE(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$B$2:$B$250)&" "&(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$C$2:$C$250))),(SUMIF('Work submitted'!$A$2:$A$250,A2,'Work submitted'!$B$2:$B$250)))

The data I want is a score and if it was late. If it wasn't late, all I want is the score.

 

[El Gallo]

Ok, how about

=SUM(FILTER(Table1[Total points],Table1[Name]=A2,0))&" "&TEXTJOIN(", ",,FILTER(Table1[Late],Table1[Name]=A2,""))

Huzzah! That's it for real! You have been so kind to share your knowledge with a plebe like me. I owe you a virtual drink! I certainly will tip one back in your honor. Thank you so much.

 

[Fluff]

Glad to help & thanks for the feedback.