Caleeco
Well-known Member
- Joined
- Jan 9, 2016
- Messages
- 980
- Office Version
- 2010
- Platform
- Windows
Hello,
I am trying to set up an excel formula that will SUM currencies. However, they are listed without the currency format, so I need to convert EUR to GBP.
I can achieve this using 2 SUMIF functions. However, from what i've read a much slicker formula could be achieved using LOOKUP and SUMPRODUCT.
Formula in E3:
Formula in F3:
Can anyone tell me why my formula in F3 doesn't resolve correctly?
Many Thanks
Caleeco
I am trying to set up an excel formula that will SUM currencies. However, they are listed without the currency format, so I need to convert EUR to GBP.
I can achieve this using 2 SUMIF functions. However, from what i've read a much slicker formula could be achieved using LOOKUP and SUMPRODUCT.
Formula in E3:
Code:
=SUMIF(G6:G23,"GBP",H6:H23)+(SUMIF(G6:G23,"EUR",H6:H23))/K6
Formula in F3:
Code:
=SUMPRODUCT((LOOKUP(G6:G23,{"GBP","EUR"},{1,1.24})),H6:H23)
Can anyone tell me why my formula in F3 doesn't resolve correctly?
Many Thanks
Caleeco
Last edited: