1 | 類型 | |||||||
|---|---|---|---|---|---|---|---|---|
2 | 日期 | 活動名稱 | 時數 | 人數 | 參訪 | 會議 | 活動 | |
3 | 1/32 | 課程博覽會 | 3 | 500 | y | |||
4 | 2/30 | 教師工作坊 | 8 | 30 | y | |||
5 | 3/32 | 理財講座 | 3 | 50 | y | |||
6 | 4/31 | 平板工作坊-1 | 2 | 35 | y | |||
7 | 5/32 | 社大聯合會 | 3 | 25 | y | |||
8 | ||||||||
9 | ||||||||
10 | 次數 | 0 | 2 | 3 | ||||
11 | =countif(F3:F8,"y") | =countif(G3:G8,"y") | =countif(H3:H8,"y") | |||||
12 | 時數 | 0 | 11 | 8 | ||||
13 | =sumif(F3:F8,"y",$C3:$C8) | =sumif(G3:G8,"y",$C3:$C8) | =sumif(H3:H8,"y",$C3:$C8) | |||||
14 | 人次 | 0 | 55 | 585 | ||||
15 | =sumif(F3:F8,"y",$D3:$D8) | =sumif(G3:G8,"y",$D3:$D8) | =sumif(H3:H8,"y",$D3:$D8) |