Hello I have an excel statistics question and need help with how to get the countif and sumif function parts of the question. I am having trouble understanding how to get the function and how many sales were completed and the total value of their sales individually on excel

1. Create sumif/countif tables using the data below: Order # Revenue Salesperson Location 7002-3512 $81,919 Vishal Madera 7002-3513 $24,967 Miguel Fresno 7002-3514 $257,541 Anna Madera 7002-3515 $86,106 Harry Fresno 7002-3516 $124,663 Vishal Clovis 7002-3517 $77,266 lenny Fresno 7002-3518 $102,497 Harry Fresno 7002-3519 $80,457 Vishal Madera 7002-3520 $74,446 Vishal Hanford 7002-3521 $125,629 Anna Tulare 7002-3522 $104,885 Harry Madera 7002-3523 $96,316 Anna Clovis 7002-3524 $83,995 Miguel Fresno 7002-3525 $62,062 Miguel Fresno 7002-3526 $87,530 Harry Clovis 7002-3527 $23,900 Miguel Hanford 7002-3528 $55,328 Harry Hanford 7002-3529 $87,642 Miguel Fresno 7002-3530 $66,101 Anna Madera 7002-3531 $93,790 Anna Clovis 7002-3532 $156,868 enny Tulare 7002-3533 $118,733 Harry Fresno 7002-3534 $150,137 Anna Clovis 7002-3535 $44,047 Miguel Fresno 7002-3536 $70,849 Miguel Fresno 7002-3537 $46,956 Harry Madera 7002-3538 $225,212 lenny Tulare 7002-3539 $86,037 enny Madera 7002-3540 $249,111 Vishal Clovis 7002-3541 $29,007 Harry Fresno 7002-3542 $106,468 Visha Madera 7002-3543 $28,130 Vishal Hanford 7002-3544 $83,646 Anna Fresno 7002-3545 $162,488 lenny Madera 7002-3646 $11,531 Harry Clovis 7002-3647 $271,186 Miguel Tulare 7002-3648 $64,623 Anna Fresno 7002-3649 $55,298 Anna Clovis 7002-3650 $126,454 lenny Fresno 7002-3651 $146,338 Vishal Fresno Table 1: List Salesmen in an alphabetical order and count how many sales they completed and find the total value of their sales (revenue) individually. Sales Person Countif Sumif