Friday 3 May 2013


If required, Excel is able to add or count only records which agree with a statement. These formulas are quick-and-easy and structured as follows:


SUMIF will sum a column if the corresponding cell in another column is true. COUNTIF will count the number of records which are true.


No comments:

Post a Comment