Forum Discussion
Samik_Sood
Dec 19, 2022Copper Contributor
formula for adding into vote count whenever a name is mentioned under 1-3 points?
OliverScheurich
Dec 19, 2022Gold Contributor
=IFERROR(INDEX($B$1:$D$1,,SUMPRODUCT((F2=$B$2:$D$5)*COLUMN($A$1:$C$1))),"")
You can try this formula.