Muultiple Radio Button Selections then Output to Summary Table

[heatwave]

Hi guys,

I have been used to using IF(AND, IF(OR and multiple nested commands to obtain result to a table.

This time I want to make the process easier with pictures and radio buttons. I have been unable to understand how the radio button work in terms of selecting multiple buttons and output to a table.

The idea is simple, select the radio button for that item, enter the QTY next to it (there are several products of course) and then a table will display my summary of what I have selected.

Attached excel file will explain in better detail.

[mehmetcik]

The radio button is pointless in your setup

a simple formula is all you need.

for example put this in E18.

Please Login or Register  to view this content.