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.

[shivya]

=IF(B1="Home",SUMPRODUCT(--(Sheet2!$B$2:$B$2400=Sales!$A$1),--(Sheet2!$D$2:$D$2400=Sales!A4)),SUMPRODUCT(--(Sheet2!$C$2:$C$2400=Sales!$A$1),--(Sheet2!$E$2:$E$2400=Sales!A4)))

You can change range according to you.

[andyh42]

Thank you don't use you very often but always very quick and precise. have a great day