In an earlier post I demonstrated How to sum cells with multiple criteria in Excel 2003. I used an Array Formula consisting of the SUM function and the IF function.
In Excel 2007 however a new function is introduced that facilitates sum with multiple criteria: the SUMIFS function.
Syntax
SUMIFS (sum_range, criteria_range1, criteria1, criteria range2, criteria2…) … up [...]
If you want to validate a cell to restrict data entry to values in a drop-down list follow these steps:
Select the cell you want to validate.
On the Data tab, in the Data Tools group, click Data Validation.
The Data Validation dialog box will open.
In the Data Validation dialog box, click the Settings tab.
Click on the Allow [...]
To calculate a running average, or a moving average, for a range of cells (a column), you use the AVERAGE function. The only trick you need to apply is to make your range changing continuously.
In the example below we want to calculate the running average of the sales from January to June.
Our ranges for the [...]
