if sumproduct query.

[andyh42]

Hi,
I'm using excel 2016 on windows 10

Having trouble with adding sumproduct into an if command.

I have two sales teams with 20 people in. In cell B1 on the sales page I want to either put team a or team b then do a sumproduct on the each team member by rank cell A1 on sales page sum by the number of sales.

I've attached a file with the sumproduct already in a working but only for team a I would like to beable to change cell b1 to team b and get the same answers for them.

Regards.