Forum Discussion
Include number in sum only if other cell=1
I'm sure this is quite simple but I'm not very experience with excel.
I have many items laid out like below. Each has an option button for a binary choice. Lets say red or blue, and each ite...
The link cell is controlled by the radio buttons. I'd like to use this formula multiple times for all the different relevant metrics for the product. Ie, the sum of all red items costs, the sum of all red items revenue, etc. The radio button returns 1 if the product is red, 2 if blue.
Please read my other comment again. You did not answer the question I asked there.
I do understand that the radio button changes the value of a cell. That's how radio buttons work.I need to know where in the spreadsheet the data is that relates to the radio button linked cells. Your screenshot does not show the data to be summed, only the cell with the radio button link. So, where is the data to add up? And how does it relate to the link cell? Is it in the same row? If it is not in the same row, is there a logical position? Like always three rows below the link cell or something like that?
