Microsoft Office Tutorials and References
In Depth Information
Using conditional functions
If a label in the column of criteria includes an invisible space character at the end of
the text string, Excel excludes it from the total, even if all the instances are otherwise
Figure 12-40 You can use the SUMIFS function to specify up to 127 sets of criteria.
Figure 12-41 With the COUNTIFS function, you can use multiple criteria to tally the number of
times the specified condition occurs.