excel 组合框的数据源区域怎么写成固定值，比如 甲，乙，...-excel甲乙对丙丁,甲乙丙丁分别是多少分

只有一列需要判断，就用条件求和sumif()，如果条件多，可以用多条件求和sumifs()

combobox1.list = array("甲","乙","丙","丁")

简单的使用两层for循环即可了

关键还是看楼主的进一步明确需求的

就是各场比赛之间怎么间隔的

就是增加对行号的控制即可

请追加说明，不要再评论了

初步想到四种函数方法处理。
方法一、输入公百式=MID("甲乙丙丁戊己庚辛壬癸",INT(RAND()*10+1),1)
方法二、输入公式度=CHOOSE(INT(RAND()*10+1),"甲","乙","丙","丁","戊","己","庚","辛","壬","癸")
方法三、输入公式=LOOKUP(INT(RAND()*10+1),{1,2,3,4,5,6,7,8,9,10},{"甲","乙","丙","丁","戊","己","庚","辛","壬","癸"})
方法四、=VLOOKUP(INT(RAND()*10+1),{1,"甲";2,"乙";3,"丙";4,"丁";5,"戊";6,"己";7,"庚";8,"辛";9,"壬";10,"癸"},2,0)
选择输入一种公式后向下填充即可得到一列甲乙丙丁回…答…的数据。