SUM cells from list IF associated cells have "1" or "0)

Dear experts, I am trying to sum all cells that have an associated cell with 1 or 0. The association will change dependant on the position of the chain (ie it will be in same row or a row X above m...

sum if in 1 or 0 chain.xlsx767 KB

Formulas & Functions

Need Help

Jamil
Mar 09, 2018
What is the version if your Excel? if you have Excel 365 then you can use AVERAGEIF function.

if not then you can use this formula =AVERAGE(IF($B$2:$B$41=1,$C$2:$C$41,""))

remember to enter it with control shift enter because it is an array formula.

for the other one simply change the =1 to =0

Forum Discussion

SUM cells from list IF associated cells have "1" or "0)

Resources