- Absolute reference
This absolute ref. is for keep the particular cell locked ( if H$18 means cell will be locked only left sides ) by typing $H$18 in equation. By the way there is shortcut for this function
> Window:F4 / Macs: CMD+ T
- Paste transpose: Paste table by switching rows and columns
- Count family
> Count: count only number of cells
> CountA: count all of cell (no matters what type of data)
>CountIF: count cell in a given condition
>CountBlank: count empty cells
- SumIF/AverageIF: Total/average of the selected cells in a given condition
> =SUMIF(Range,”criteria”)
- MaxA/MinA: The maximize/minimize of the number in the range of cell
- SumIFS/ AverageIFS: Total/average of value in given set of criteria
>SUMIFS(range of value, range of criteria, criteria)
- Concatenate: To link data of cells together in a chain
By the way, there is another method in case you want to add space between selected cells by manually typing in the function bar: =C33&” “&D33