Hello,

Were looking to make a spreadsheet that will work out how much vinyl we need for a run of prints

I'm not sure if we should use an IF function or a VLOOKUP function for this

Basically we would like the formula that will look down our A column, spot all of the "y"s and give us the SUM of the corresponding cells in the E column. Only the ones with the "Y", if "N" shows it should just be ignored

Is this possible and if so how would i go about constructing the formula?

Ive attached a photo of the spreadsheet for your reference

Screen Shot 2015-05-12 at 15.22.32.png