作者:乔山办公网日期:
返回目录:excel表格制作
C1输入百公式度:问
=IF(OR(A1<=10000,B1<=1000),"a",IF(OR(A1<=100000,B1<=10000),"b",IF(OR(A1<=200000,B1<=30000),"c",IF(OR(A1<=50000000,B1<=1000000),"d","e"))))
下拉答填内充。容
=SUMPRODUCT(($C$1:$C$12="张三")*($D$1:$D$12=1))
这里的C和D ,就是你描述的A和B列。
把你公式贴出来。
B2用公式:
=IFERROR(INDEX(Sheet1!zhidao$C:$C,MATCH($A2&B$1,Sheet1!$A$1:$A$1000&Sheet1!$B$1:$B$1000,)),"")
数组公式,回按三键(CTRL+SHIFT+回车)完成公式,右拉,下拉答。