excel sumif
1 TopicInclude 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 item has a linked cell off to the right. The end goal is to sum the different other metrics based on red/blue for each product. I can find a formula that says sum these numbers if this cell is 1/2, but what I'm looking for is more like "include this number in sum formula if it's respective linked cell =1" something like total = if(linkedcell1=1 then include A1) + (if linkedcell2=1 then include A5). So I can get the sum of say our cost or sale price for all items that are red. Can someone help me out? Thanks so much!1.5KViews0likes3Comments