如图,我要在sheet2和shee3t和sheet5中的第一列查找有A的单元格,在sheet1中用countif(range,"A"),这range怎么写?
我还要用if函数,若有A则返回1,没有是0.=IF(COUNTIF(sheet1!A:A,"a"),"1","0")但现在查找的范围有好几张表
您好,其实是这样子的,我还要用if函数,若有A责返回1,没有是0.
=IF(COUNTIF(sheet1!A:A,"a"),"1","0")
但现在查找的范围有好几张表,您有办法不
=IF(SUM(COUNTIF(INDIRECT("SHEET"&{2,3,5}&"!A:A"),"A")),1,0)
不知道你要的是不是这样的结果?
是的,但我尝试了,不行啊,显示错误,我的每个表都是有名字的,不是sheet12和shee3t和sheet5
追答那就分开写:
=IF(COUNTIF(A表!A:A,"A")+COUNTIF(B表!A:A,"A")+COUNTIF(C表!A:A,"A"),1,0)