Hi everyone, I have a spreadsheet that contains formulas using if(and. for example:
=if(and(e5<j5,d5="",c5<>0),1,0)
This formula will return either 1 if true or 0 if false. I use this formula in a column (k)that has 100 rows of data and I want to have a formula in row 101 that gives the sum of the column. For some reason when I enter the formula =sum(k5:k105) it won't calculate the sum. I have formatted the column to be numbers.
Does anyone know why I can't sum up the column?
Thanks
Abe
=if(and(e5<j5,d5="",c5<>0),1,0)
This formula will return either 1 if true or 0 if false. I use this formula in a column (k)that has 100 rows of data and I want to have a formula in row 101 that gives the sum of the column. For some reason when I enter the formula =sum(k5:k105) it won't calculate the sum. I have formatted the column to be numbers.
Does anyone know why I can't sum up the column?
Thanks
Abe