EXCEL,我想计算固定数值1连续出现次数,当出现数值0时总数归0,自动开始...答:可以通过两步来实现;1、在A2中输入:=IF(A1=1,1,0)2、在A3中输入:=IF(B1=1,A2+1,0),向后拖动至G2生成 截图如下:A2中公式:=IF(A1=1,1,0)B2中公式:=IF(B1=1,A2+1,0)
EXCEL统计数字大于0在一行中连续出现的最大次数,用数组公式求的,怎么...答:=SUM(OFFSET(A1,MATCH(MAX(FREQUENCY(IF(A1:A12>0,ROW(A1:A12)),IF(A1:A12>0,,ROW(A1:A12))),FREQUENCY(IF(A1:A12>0,ROW(A1:A12)),IF(A1:A12>0,,ROW(A1:A12))),)-MAX(FREQUENCY(IF(A1:A12>0,ROW(A1:A12)),IF(A1:A12>0,,ROW(A1:A12))...