Forum Discussion
Solved
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...
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
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
Thank you for your help Jamil.
- You are welcome. Thanks for the feedback.
