Formula for calculating two currencies in one column

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?

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


for total spends in LD.



for total spends in USD.

1 Like

Thank you so much.
It worked!

1 Like