Windows shortcut  Ctrl` Mac shortcut  ⌃` This shortcut will toggle between displaying cell values and cell formulas. You can use this shortcut to ...

Windows shortcut  F8 Mac shortcut  FnF8 With extend selection enabled, you don't need to press Shift to extend the current selection. 0 ...

Windows shortcut  CtrlShiftL Mac shortcut  ⌘⇧F This shortcut toggles filters on and off for a range of data. It works on tables or filtered lists, ...

Windows shortcut  ShiftF8 Mac shortcut  Fn⇧F8 With add to selection mode enabled, you don't need to hold down the control key to add ...

Windows shortcut  F4 Mac shortcut  ⌘T While editing a formula, this shortcut toggles cell references from relative to absolute, to partially ...

Example Related FunctionsCOUNTIF =COUNTIF(range,criteria)When working with data, a common need is to perform summary calculations that show total counts ...

Example Related FunctionsSUM =SUM(SUMIFS(sum_range,criteria_range,{"black","red"}))To sum based on multiple criteria using OR logic, you can use the ...

Example Related FunctionsSUBTOTAL =SUBTOTAL(9,range)If you want to sum only the visible rows in a filtered list (i.e. only those rows not filtered out), ...

Example Related FunctionsINDIRECT ROW SUM SUMPRODUCT LARGE =SUMPRODUCT(LARGE(rng,{1,2,N}))To sum the top values in a range, you can use a formula based ...

Example Related FunctionsSUM =SUM(range)If you need to add up (sum) up race time splits that are some combination of hours, minutes, and seconds, you ...