Screenshots Question Top Stuck Use Sumif Averageif Properly Q34255760

Both screenshots have a question at the top. I am stuck on howto use SUMIF and AVERAGEIF properly.

Expert Answer

SUMIF

Excel Row and Column headers are not shown in the tables. So,assuming that address of cell “Job ID” of Table 1 is B15

So, address of data in ‘Difficulty’ field of Table 2 is$D$40:$D$46

address of ‘Cost’ field of Table 2 is $E$40:$E$46

The formula in first empty cell of ‘Cost Touch-ups’ field inTable 4 will be

=SUMIF($D$40:$D$46,G46,$E$40:$E$46)

this formula is copied in rest of the empty cells in ‘CostTouch-ups’ field in Table 4

AVERAGEIF

address of data in ‘Difficulty’ field of Table