combo box for Excel

I am trying have my combo box calculate across cells and put total on another page.

something example not a real code:

private sub combobox_Change()

if Me.combox1.select = "lays" then
=sum(B6:I6) place answer into cell("b29")
elseif
if me.combox1.select = "fritolay" then
=sum(B6:I6) place answer into cell("b29")
elseif
if me.combox1.select = "fritolay" then
=sum(B6:I6) place answer into cell("b29")
elseif
end sub

Day2 worksheet

private sub combobox11_Change()

if Me.combox1.select = "lays" then
=sum(B6:I6) place answer into cell('Day1'!b29)
elseif
if me.combox11.select = "fritolay" then
=sum(B6:I6) place answer into cell('Day1'!b29)
elseif
if me.combox11.select = "fritolay" then
=sum(B6:I6) place answer into cell('Day1'!b29)
elseif
end sub

and so on.