Possible to Calculate with 3 variables

Hi all,

My excel file is attached. Once I was supported by another forum to build Sheet Event procedure included in file. It is Ok to calculate with 2 variables (Accommodation Type & Board) but can not succeeed to calculate with 3rd variable (Room Type). How can it be reducted to calculate depending 3 variables (Room Type + Accommodation Type + Board)

Thanks in advance for your kindest promts.