## Toggle formulas on and off

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

## Toggle extend selection mode

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

## Toggle Autofilter

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, ...

## Toggle add to selection mode

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 ...

## Toggle absolute and relative references

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

## Summary count with COUNTIF

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

## SUMIFS with multiple criteria and OR logic

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

## Sum visible rows in a filtered list

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), ...

## Sum top n values

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 ...

## Sum race time splits

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 ...