Below is a data table with sales reps names and their sales results on a monthly basis. [Spreadsheet Modeling]

Using the IF or SUMIF functions in excel, calculate what the total dollar amount of sales was in August from sales reps who made more than $20,000 dollars in sales that month.

$150,000

$149,000

$136,000

$135,000

M17 4 x y f A B D E F July Sales August Sales 11000 13400 35000 13450 1 Employee 2 Jane 3 Gabe 4 Ryan 5 Chong 6 Alex 7 Clara 8 Julia 9 Samantha 10 Keri 11 September Sales 40000 10000 34000 13400 10000 33000 40000 10000 13000 40000 10000 13000 13400 40000 40000 34000 10000 Doc 40000 35000 13450 34000 13450 13000 12 13 14 15