I was hoping someone could shed a little light on userforms for me, specifically adding in a formula the sum of option buttons.

So what I mean is I have a list of names in column A which my userform will read, for each name I need to complete a calculation(simple sum) and put the outpu in column K.

I have three frames each with 4 optionbuttons. Button 1, 2,3 & 4. I was planning to use an offset for each column.

In the ok/update button what is the best flow to use intially I thinking an if else flow but seemed a little overkill.

All I want to do is say selection from group one plus selection from group two the selection from group 3.