Microsoft Office Tutorials and References
In Depth Information
Using conditional functions
CAUTION !
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
identical.
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.
Search JabSto ::




Custom Search