李恩銘EXCEL函數COUNTIF樞紐分析 

1	133	一組	17	第一四分位
2	109	二組	23	第二四分位
3	126	三組	35	第三四分位
4	136	四組	114	第四四分位
				
sum	504			

  計數 - 題目長度	欄標籤				
列標籤	1	2	3	4	總計
1	29	31	32	41	133
2	22	29	26	32	109
3	39	26	36	25	126
4	42	41	33	20	136
總計	132	127	127	118	504

留言

張貼留言

這個網誌中的熱門文章

李恩銘EXCEL串接字串concatenate試算表歷史

圖片
嵌入embed影片 嵌入網頁電子試算表發展歷史 excel常用函數 https://www.w3schools.com/excel/excel_functions.php Function Description =AND Returns TRUE or FALSE based on two or more conditions =AVERAGE Calculates the average (arithmetic mean) =AVERAGEIF Calculates the average of a range based on a TRUE or FALSE condition =AVERAGEIFS Calculates the average of a range based on one or more TRUE/FALSE conditions =CONCAT Links together the content of multiple cells =COUNT Counts cells with numbers in a range =COUNTA Counts all cells in a range that has values, both numbers and letters =COUNTBLANK Counts blank cells in a range =COUNTIF Counts cells as specified =COUNTIFS Counts cells in a range based on one or more TRUE or FALSE condition =IF Returns values based on a TRUE or FALSE condition =IFS Returns values based on one or more TRUE or FALSE conditions =LEFT Returns values from the left side of a cell =LOWER Reformats content to lowercase =MAX Returns the highest value in a range =MEDIAN Returns the middle v...
閱讀完整內容