The result appears in cell E1. Take a tour Download template Formula tutorial Download template Make your first PivotTable Download template Get more out of PivotTables Download template Other versions. The best way to speed up your day-to-day Excel work is to learn some useful shortcuts both with the keyboard and your mouse or touchpad.
Press Enter to complete the formula.
Simply use the SUM function to shorten your formula. How to Quickly Become an Excel Expert Method 1of 4. IF VLOOKUP pivot tables and charts including line charts column charts and 3D column charts. IF A23 Yes No 4.