8)

1). Using the date in Bank Data tab, calculate the following using both SUMIF function and SUM/IF functions with arrays. Name the ranges of cells and use the name in the formula. a. Toal balance in N. county b. Total balance of checking accounts c. Total balance of CD in Central county d. Total balance of savings in Westside county before 9/102002 (Hint:use Date