I'm having an issue with a formula in excel. I have two columns, "Deposit" and "Cleared". I want to be able to calculate the total of each cell in the "Deposit" column if the "Cleared" cell has a "Y". I've tried messing around with the "if" function, but I keep getting errors.
Thanks ahead of time.
Thanks ahead of time.