COUNTIF, Counts numbers of cells in a given range, SUMIF, Always comes after counting, NestedIF, When there are more than 2 possible conditions, VLookup, Used based on a portrait orientated table, HLookup, Used based on a landscape orientated table, Minimum, Shows the smallest amount in a range, Maximum, Shows the highest amount in a range

Higher Admin - Formulas

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?