SumIf

Closed
GoGoGizmo Posts 1 Registration date Monday February 1, 2016 Status Member Last seen February 1, 2016 - Feb 1, 2016 at 05:01 PM
I have a column E with dollar values. I have a column L with "y" or "n"; I'm trying to figure out a formula that could sum only the values in column E, if the corresponding column is "y".

ie
100,000.00 N
25,800.00 Y
57,000.00 Y
125,000.00 N

The formula would only add 25,800 and 57,000 returning sum of 82,800.

If, for example, the column next to 25,800 was N, then the sum would be 57,000