You can sum a series of numbers in Excel manually or automatically ... you have a column or row of numbers you want to add. 1. Click the cell under a column of numbers you want to add.

A basic formula might look like this: =A2+B2. This basically tells Excel to add the number in cell A2 to the number in cell B2, and then show the result in the cell where you typed the formula.

The COUNTIF function is used for one condition, while COUNTIFS allows multiple conditions to be specified in Excel. When ...