Solve an average size - want to look at name on tab QScorecard B3, then look at the data tab - needs to sumifs ( new/existing business) column C, and Column D = Closed won and return ($$$$) then also countifs same criteria but solve ($$$$)/ count to give us the Average size
Solved by F. E. in 11 mins