sumif or sumifs or sumproduct help

Copper Contributor

Hi All 

 

i work in global payroll - i have a spread sheet consisting of 

Currency ie (usd), salary,bonus, commission, and a fx rate table  I need to add the bonus and commission together and * by the correct currency to get my variables in gbp. I have a lot of employees and currency's . what sum can i put in that will add up my variables and then find the correct fx rate and  calculate it. 

 

From #startingtogocraxy

 

 

 

1 Reply
Please attach your sample file to facilitate the determination of the formula applicable to your situation.