Values that are on one line equal value of several lines.

[S P P]

Goodnight!
I can get a formula for this question.

 

[pecoflyer]

There is no question in your post

 

[GraH - Guido]

Also, the set-up of the game is badly explained.

What if you have more hits then defined in the header? That's ambiguous. I'm not looking further.



Basic formula used =SUM(COUNTIF(C3:Q3,'Sweepstakes Results'!$C$3:$H$10))

 

[deciog]

SPP, Bom Dia.

The ideal is to post a model with the expected result, check if this is the way you want

Decio

 

[S P P]

GraH - Guido

Good Morning!

Thank you for joining this Topic.



deciog

Good Morning!

This is just what I need.

Thank you so much for being able to count on you again.

I'm posting it again to demonstrate how you found the result so that other members can understand.

 

[deciog]

Thanks for the feedback, I'm glad I helped

Hugs

decio

 

[S P P]

deciog

One more detail

It has the possibility of being just like in the image

 

[deciog]

SPP

Maybe this way, making tricks.
I didn't understand the second questioning result 1 2 4 and 8, it explains better

decio

 

[S P P]

I'm sending a demo on this example.

 

[GraH - Guido]

Oh my.... It's about returning the numbers with x matches?
Never occurred in my mind this could have been a way to look at this challenge.

 

[deciog]

SPP

Check if it is this way

decio

 

[S P P]

deciog

Good Morning!

I made this example better to understand

 

[deciog]

SPP

Check if it is this way

decio

 

[S P P]

deciog

Worked perfectly

With this last example it was easy to understand

I now have to find a way to prevent repeating the numbers C3:Q3 in the other C4:Q1048576

Thank you so much again