=ROW(INDIRECT(DATE(3,4,5)&":"&DATE(3,4,7)))数组公式,要加CTRL+SHIFT+回车三键,会返回ROW({$1191:$1193}) ROW({$1191:$1193})意思为返回第1191行至1193行的行号值,该值为{1191,1192,1193}因为没有用上其他函数进行配合,所以只会得出值为1191(即数组的第一个值)
如果用上SUM函数,如=SUM(ROW(INDIRECT(DATE(3,4,5)&":"&DATE(3,4,7)))),则=SUM(ROW({$1191:$1193}))=SUM({1191,1192,1193})=3576