Think about the example (below), and carefully describe how you would construct a 'Server Sales - Sunday Evening' table (total sales per server for only Sunday evening shifts).

What columns are required to calculate the Sunday evening total per server, and specifically, what Excel function best meets the need? Give an example of the function syntax for 'Sunday Evening Total'?

E 7 Sun 8 Sun A B. D 1 Sales by Server - Week of Jan 1-8 2 Day Shift Server Nightly Sales 3 Sun Evening Alishia 2,600.71 4. Sun Day Alishia 2,682.33 5 Sun Evening Carol 2,578.45 6 Sun Evening Hugo 2,608.13 Evening Meredith 1,938.03 Day Bryan 1,678.69 9 Sun Evening Bryan 2,796.24 10 Sun Evening Todd 2,404.86 11 Sun Evening Mary 2,395.43 12 Sun Evening Margo 2,244.54 13 Sun Day Jake 2,032.34 14 Sun Day Jerri 1,268.45 15 Sun Evening Jerri 1,504.23 Day Rhea 1,524.81 17 Mon Evening Rhea 1,320.76 18 Mon Day Carol 2,200.03 19 Mon Evening Carol 1,892.10 F G Total Sales Per Server Server Weekly Sales Alishia $ 25,558 Arty $ 1,950 Bryan $ 11,736 Carol $ 22,708 Hugo $ 16,401 Jake $ 8,529 Janna 3,978 Jerri $ 4,372 Josh $ 10,450 Justina $ 16,999 Lexi $ 15,826 Marcus $ 15,284 Margo $ 3,477 Mary $ 4,371 Meredith $ 21,826 Rhea $ 19,432 Todd $ 4,587 16 Mon E 7 Sun 8 Sun A B. D 1 Sales by Server - Week of Jan 1-8 2 Day Shift Server Nightly Sales 3 Sun Evening Alishia 2,600.71 4. Sun Day Alishia 2,682.33 5 Sun Evening Carol 2,578.45 6 Sun Evening Hugo 2,608.13 Evening Meredith 1,938.03 Day Bryan 1,678.69 9 Sun Evening Bryan 2,796.24 10 Sun Evening Todd 2,404.86 11 Sun Evening Mary 2,395.43 12 Sun Evening Margo 2,244.54 13 Sun Day Jake 2,032.34 14 Sun Day Jerri 1,268.45 15 Sun Evening Jerri 1,504.23 Day Rhea 1,524.81 17 Mon Evening Rhea 1,320.76 18 Mon Day Carol 2,200.03 19 Mon Evening Carol 1,892.10 F G Total Sales Per Server Server Weekly Sales Alishia $ 25,558 Arty $ 1,950 Bryan $ 11,736 Carol $ 22,708 Hugo $ 16,401 Jake $ 8,529 Janna 3,978 Jerri $ 4,372 Josh $ 10,450 Justina $ 16,999 Lexi $ 15,826 Marcus $ 15,284 Margo $ 3,477 Mary $ 4,371 Meredith $ 21,826 Rhea $ 19,432 Todd $ 4,587 16 Mon