basically i have a column with drop down list with 4 items in it, (rnwl , NB, h NB, h rnwl)
i want one sell to look down the column and if it = rnwl or NB i want it to add them together and put the sum in the cell im writing the forumla in.

i also want one for the "h nb" and "h rnwl" to add together and put the sum in the cell im putting the forumla in

Any help with this as soon as possible would be great

Thanks
Rexy