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...
Hello,
what is the relationship between the linkcell and the cell in column A? Are they on the same row?
If so, you could use a Sumif() or a Sumifs() function, like this (assuming the linkcell values are in column L, change as required)
=Sumifs(A:A,L:L,1)