For example EDATE 91519-5 returns 41519. Type the plus sign into the formula after A3. For example A2A2A3A4 is a formula that adds up the values in cells A2 through A4.
Excel multiplies the last two numbers and adds the first number to the result.
You can use AutoSum to quickly sum a column or row or numbers. Add to formula with shortcut keys Add to formula with Kutools for Excel. Press and hold Ctrl and click on each cell you want to concatenate. How to total numbers in Excel using the SUM function and autosum feature.