USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS 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 in Excel allows us to enter up to 127 range/criteria pairs for this formula. Remember: SUMIFS will return a numeric value. Rows and columns should be the same in the criteria range argument and the sum range argument.
Detailed explanation-3: -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.