Example Related FunctionsSUBTOTAL =SUBTOTAL(3,range)If you want to count the number of visible items in a filtered list, you can use the SUBTOTAL ...

Example Related FunctionsMATCH ROW SUMPRODUCT FREQUENCY =SUMPRODUCT(--(FREQUENCY(MATCH(data,data,0),ROW(data)-ROW(data.firstcell)+1)>0))If you need ...

Example Related FunctionsSUM FREQUENCY {=SUM(--(FREQUENCY(IF(criteria,values),values)>0))}If you need to count unique numeric values in a range with ...

Example Related FunctionsSUM COUNTIF FREQUENCY =SUM(--(FREQUENCY(data,data)>0))If you need to count unique numeric values in a range, you can use a ...

Windows shortcut  CtrlShift" Mac shortcut  ⌃⇧" This shortcut copies the value in the cell above to the selected cell and leaves the cell in edit ...

Windows shortcut  CtrlC Mac shortcut  ⌘C Copy puts everything on the clipboard: text, formulas, formatting, borders, fills, etc. Use Paste Special ...

Windows shortcut  Ctrl' Mac shortcut  ⌃' This shortcut copies the formula in the cell above to the active (current) current cell and leaves the ...

Windows shortcut  Enter Mac shortcut  Return This shortcut confirms any change make to a ribbon control. 0 votes. 0 / 5 .rate-title { ...

Windows shortcut  CtrlEnter Mac shortcut  ⌃Return With a single cell selected, this shortcut will enter a value and leave the same cell selected. ...

Windows shortcut  AltF4 Mac shortcut  ⌘Q This shortcut will close Excel. On a Mac, you can use Command + Q to quit almost any application. On ...