excel的使用

一个日历引用

IF(1=2,"","wrong")	#wrong
SUM(2,3,4)	#9
INDIRECT("B"&SUM(3,4))	#B7
ROW(B4)   #4

=IF(INDIRECT("sum!b"&SUM(ROW(B4),3,26))=0,"",INDIRECT("sum!b"&SUM(ROW(B4),3,26)))	=IF(INDIRECT("sum!c"&SUM(ROW(B4),3,26))=0,"",INDIRECT("sum!c"&SUM(ROW(B4),3,26)))	=IF(INDIRECT("sum!d"&SUM(ROW(B4),3,26))=0,"",INDIRECT("sum!d"&SUM(ROW(B4),3,26)))	=IF(INDIRECT("sum!e"&SUM(ROW(B4),3,26))=0,"",INDIRECT("sum!e"&SUM(ROW(B4),3,26)))	=IF(INDIRECT("sum!f"&SUM(ROW(B4),3,26))=0,"",INDIRECT("sum!f"&SUM(ROW(B4),3,26)))	=IF(INDIRECT("sum!g"&SUM(ROW(B4),3,26))=0,"",INDIRECT("sum!g"&SUM(ROW(B4),3,26)))	=IF(INDIRECT("sum!h"&SUM(ROW(B4),3,26))=0,"",INDIRECT("sum!h"&SUM(ROW(B4),3,26)))

=IF(INDIRECT("sum!b"&SUM(ROW(B6),2,26))=0,"",INDIRECT("sum!b"&SUM(ROW(B6),2,26)))	=IF(INDIRECT("sum!c"&SUM(ROW(B6),2,26))=0,"",INDIRECT("sum!c"&SUM(ROW(B6),2,26)))	=IF(INDIRECT("sum!d"&SUM(ROW(B6),2,26))=0,"",INDIRECT("sum!d"&SUM(ROW(B6),2,26)))	=IF(INDIRECT("sum!e"&SUM(ROW(B6),2,26))=0,"",INDIRECT("sum!e"&SUM(ROW(B6),2,26)))	=IF(INDIRECT("sum!f"&SUM(ROW(B6),2,26))=0,"",INDIRECT("sum!f"&SUM(ROW(B6),2,26)))	=IF(INDIRECT("sum!g"&SUM(ROW(B6),2,26))=0,"",INDIRECT("sum!g"&SUM(ROW(B6),2,26)))	=IF(INDIRECT("sum!h"&SUM(ROW(B6),2,26))=0,"",INDIRECT("sum!h"&SUM(ROW(B6),2,26)))

=IF(INDIRECT("sum!b"&SUM(ROW(B8),1,26))=0,"",INDIRECT("sum!b"&SUM(ROW(B8),1,26)))	=IF(INDIRECT("sum!c"&SUM(ROW(B8),1,26))=0,"",INDIRECT("sum!c"&SUM(ROW(B8),1,26)))	=IF(INDIRECT("sum!d"&SUM(ROW(B8),1,26))=0,"",INDIRECT("sum!d"&SUM(ROW(B8),1,26)))	=IF(INDIRECT("sum!e"&SUM(ROW(B8),1,26))=0,"",INDIRECT("sum!e"&SUM(ROW(B8),1,26)))	=IF(INDIRECT("sum!f"&SUM(ROW(B8),1,26))=0,"",INDIRECT("sum!f"&SUM(ROW(B8),1,26)))	=IF(INDIRECT("sum!g"&SUM(ROW(B8),1,26))=0,"",INDIRECT("sum!g"&SUM(ROW(B8),1,26)))	=IF(INDIRECT("sum!h"&SUM(ROW(B8),1,26))=0,"",INDIRECT("sum!h"&SUM(ROW(B8),1,26)))

=IF(INDIRECT("sum!b"&SUM(ROW(B10),0,26))=0,"",INDIRECT("sum!b"&SUM(ROW(B10),0,26)))	=IF(INDIRECT("sum!c"&SUM(ROW(B10),0,26))=0,"",INDIRECT("sum!c"&SUM(ROW(B10),0,26)))	=IF(INDIRECT("sum!d"&SUM(ROW(B10),0,26))=0,"",INDIRECT("sum!d"&SUM(ROW(B10),0,26)))	=IF(INDIRECT("sum!e"&SUM(ROW(B10),0,26))=0,"",INDIRECT("sum!e"&SUM(ROW(B10),0,26)))	=IF(INDIRECT("sum!f"&SUM(ROW(B10),0,26))=0,"",INDIRECT("sum!f"&SUM(ROW(B10),0,26)))	=IF(INDIRECT("sum!g"&SUM(ROW(B10),0,26))=0,"",INDIRECT("sum!g"&SUM(ROW(B10),0,26)))	=IF(INDIRECT("sum!h"&SUM(ROW(B10),0,26))=0,"",INDIRECT("sum!h"&SUM(ROW(B10),0,26)))

=IF(INDIRECT("sum!b"&SUM(ROW(B12),-1,26))=0,"",INDIRECT("sum!b"&SUM(ROW(B12),-1,26)))	=IF(INDIRECT("sum!c"&SUM(ROW(B12),-1,26))=0,"",INDIRECT("sum!c"&SUM(ROW(B12),-1,26)))	=IF(INDIRECT("sum!d"&SUM(ROW(B12),-1,26))=0,"",INDIRECT("sum!d"&SUM(ROW(B12),-1,26)))	=IF(INDIRECT("sum!e"&SUM(ROW(B12),-1,26))=0,"",INDIRECT("sum!e"&SUM(ROW(B12),-1,26)))	=IF(INDIRECT("sum!f"&SUM(ROW(B12),-1,26))=0,"",INDIRECT("sum!f"&SUM(ROW(B12),-1,26)))	=IF(INDIRECT("sum!g"&SUM(ROW(B12),-1,26))=0,"",INDIRECT("sum!g"&SUM(ROW(B12),-1,26)))	=IF(INDIRECT("sum!h"&SUM(ROW(B12),-1,26))=0,"",INDIRECT("sum!h"&SUM(ROW(B12),-1,26)))

=IF(INDIRECT("sum!b"&SUM(ROW(B14),-2,26))=0,"",INDIRECT("sum!b"&SUM(ROW(B14),-2,26)))	=IF(INDIRECT("sum!c"&SUM(ROW(B14),-2,26))=0,"",INDIRECT("sum!c"&SUM(ROW(B14),-2,26)))	=IF(INDIRECT("sum!d"&SUM(ROW(B14),-2,26))=0,"",INDIRECT("sum!d"&SUM(ROW(B14),-2,26)))	=IF(INDIRECT("sum!e"&SUM(ROW(B14),-2,26))=0,"",INDIRECT("sum!e"&SUM(ROW(B14),-2,26)))	=IF(INDIRECT("sum!f"&SUM(ROW(B14),-2,26))=0,"",INDIRECT("sum!f"&SUM(ROW(B14),-2,26)))	=IF(INDIRECT("sum!g"&SUM(ROW(B14),-2,26))=0,"",INDIRECT("sum!g"&SUM(ROW(B14),-2,26)))	=IF(INDIRECT("sum!h"&SUM(ROW(B14),-2,26))=0,"",INDIRECT("sum!h"&SUM(ROW(B14),-2,26)))