sumif or sumifs or sumproduct help

Occasional Visitor

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies