USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
= KH: S16
|
|
|
=F5:F16
|
|
|
=B5:B16
|
|
|
=S5:F16
|
Detailed explanation-1: -The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. Blank and text values are ignored. The selected range may contain dates in standard Excel format (examples below).
Detailed explanation-2: -The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
Detailed explanation-3: -The first thing you need to know is the syntax for using SUMIF in a formula. The syntax, or the structure of the formula, is =SUMIF(range, criteria, sum range). Here is an example: =SUMIF(A3:A10, A1, B3:B10). One way to use the SUMIF in a formula is to add up values that are greater than or less than a specific number.