Is Mr X Attending Both Events

[ugcs93]

I want to know, from a list of event attendees, who is coming to each of two seperate events. I've pivoted my data with the names of two events as column headings but I only want a total of folks coming to both events. I tried countifs and sumifs but I don't think the range is working.
=SUMIFS(B5:C5, B5:B5, ">0", C5:C5, ">0")
EVENT 1EVENT 2ATTENDING BOTH
MR B10
MR A112
MR C10
MR D112

 

[SirJB7]

Hi, ugcs93!
The data that you posted isn't clear at all: titles start with EVENT, next rows start with MR.
Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you.
Regards!

 

[ugcs93]

Thank you - I think I've managed to upload the example..............

 

[SirJB7]

Hi, ugcs93!
Try this:
D2: =SI(SUMA(B2:C2)=2;"Sí";"") -----> in english: =IF(SUM(B2:C2)=2,"Yes","")
Copy down as required.
Regards!