if cell contains two different specific texts then return two different values

[stevie_c]

im looking for a formula that returns two seperate values based on two different texts in other columns

e.g

£10	£15
Product	Cost
Windows	10
Windows & Doors	15
Windows	10

<tbody>
</tbody>

I then need to be able to sum the total cost

Thanks

 

[KolGuyXcel]

Is it something like this?

=IF(A1="Windows",10,if(A1="Windows & Doors",15,""))

And then to get the sum (Adjust the range $B$1:$B$3 accordingly)

=SUMIF($A$1:$A$3,"Windows",$B$1:$B$3) etc.

 

[stevie_c]

works perfect, thanks for your help