鍾奕安EXCEL名稱方塊,AND,OR,COUNT,COUNTIF,INDIRECT間接定址

  #VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	25	FALSE	FALSE	=AND(ISNUMBER(T504),ISNUMBER(U504))	
#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	29	FALSE	FALSE	=AND(ISNUMBER(T505),ISNUMBER(U505))	
									這個名稱定址的資訊	
6	3	6	4	0	32	118	0	3	買權賣權	
								=COUNTIF(買權賣權,AC508)	3	TRUE
				範圍	S1:Y505				501	FALSE
				統計多少個數字	0	=COUNT(X508)				
					169	=COUNT(INDIRECT(X509))