Formula for calculating two currencies in one column

❓ Questions & help
1

I created a spreadsheet with daily expenses. We use two major currencies; Liberia dollars (LD) and United States dollars (USD).

On my spreadsheet, all expenses are in one column (C), and the currency is in the next column (D). I want to only calculate the LD to have the total in a separate cell while the total spent in USD is in another cell. Which formula can I use for both?

2

We can use SUMIFS, to calculate total spends in LD & USD individually.
Eg:

=SUMIFS(C:C,D:D,"LD")

for total spends in LD.

Similarly,

=SUMIFS(C:C,D:D,"USD")

for total spends in USD.

1 Like
3

Thank you so much.
It worked!

1 Like