### Quick Sum with Status Bar

Select the range of cells and look in the lower right corner of the Excel window to have a quick look at the sum, count, and average of the selected range of cells.

### SUMPRODUCT Function

The SUMPRODUCT function first multiplies corresponding arrays, then returns with the sum.

### (SUM Function) AutoSum by using a short key

For the AutoSum of a range of cells, follow these steps:

1- Go to a blank cell which should directly above or below the range that you want to sum then press “**Alt** + **=” **buttons.

2- Press Enter for Results.

(You can also do the same by going to the Formulas tab and select AutoSum option in Function Library section)

### SUMIF Function

To sum the range of cells with the one minimum criteria (e.g. sum numbers lower than 50), use SUMIF Function.

Result.

### SUMIFS Function

To sum the range of cells by setting minimum two criteria (e.g. sum all unit sold of a product to one party in the same state), use the SUMIFS function.