两个条件求个数 (1) >10并且<=15 =SUM(COUNTIF(data,">"&{10,15})*{1,-1}) (2) >=10并且<15 =SUM(COUNTIF(data,">="&{10,15})*{1,-1}) (3) >=10并且<=15 =SUM(COUNTIF(data,{">=10",">15"})*{1,-1}) (4) >10并且<15 =SUM(COUNTIF(data,{">10",">=15"})*{1,-1}) 请谁能帮忙解释一下此四个公式, {1,-1}是什么意思和数组是一回事么,将公式换成{=SUM(COUNTIF(data,">"&{10,15})}为什么是错误的? 第三、四个公式为什么是{">=10",">15"}和{">10",">=15"}如何理解?
|