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?