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