The SUMIF function is useful for summing values in a certain range if cells in a related range satisfy a given condition. It has the syntax =SUMIF (compareRange,criterion, sumRange), where compareRange and sumRange are similar-size ranges. This formula checks each cell in compareRange to see whether it satisfies the criterion. If it does, it adds the corresponding value in sumRange to the overall sum. For example, =SUMIF(A12: A23,1,D12:D23) sums all values in the range D12:D23 where the corresponding cell in the range A12:A23 has the value 1.
Using the poverty level excel sheet, run the SUMIF range for each quartile. Draw conclusions in one paragraph. How would you use the SUMIF in your business?
Using the CEO Salary levels excel sheet, utilize AVERAGEIF to determine comparisons for which over 50% of the highest paid CEOs fall. Draw conclusions in one paragraph. How would you use the AVERAGEIF in your business?
Read the following articles
https://www.ablebits.com/office-addins-blog/2015/02/11/excel-offset-function/
https://www.xelplus.com/excel-offset-function-for-dynamic-calculations/
Using retirement planning information, create an offset function. Be creative with what you use.
When would you use the offset function in your business?
Offset function: Retirement planning
Read the following articles
https://www.ablebits.com/office-addins-blog/2015/02/11/excel-offset-function/
https://www.xelplus.com/excel-offset-function-for-dynamic-calculations/
Using retirement planning information, create an offset function. Be creative with what you use.
When would you use the offset function in your business?