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.

Papan mata

Gaya visual

Pilihan

Tukar templat

)
Pulihkan autosimpan: ?