SumIf [Closed]

Report
Posts
1
Registration date
Monday February 1, 2016
Status
Member
Last seen
February 1, 2016
-
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