I have a SUM (A:A) cell value that calculates the sum of all cells in a certain column. However, I want to create another cell that has the sum of all cells in the same column, but exclude those cells that do not have the letter R in the neighboring cell. The reason is to calculate the sum of reconciled values only in an account.

Thanks in advance, Sammy