function - I can't sum the values of a column whose values are generated using if statement -

function - I can't sum the values of a column whose values are generated using if statement -

sum function not helping me sum column, tried manually come in cells not help. if there values in column, 0 reply in cell have entered sum function.

i have next status 10 cells in column =if(b1=0,20,2) , sum cells =sum(a1:a10). column autoupdated when b1 updated , sum updated when values of cells change.

if have different workbooks if changes =if([d.xlsx]tabelle1!$a$1=0,2,10). d.xslx name of sec workbook check value tabelle1 name of sheet , $a$1 checked cell.

function excel-formula excel-2007