M
martinbarnes
I used an "IF" function to make a column Q of "y" and "n" entries, as such:
=IF(P3>0,"Y","N")
I then used the following function:
=IF(Lines!$Q$3:$Q$57="n",SUMIF(Lines!$I$3:$I$57,"=0",Lines!$F$3:$F$57),0)
i repeated the function for "y":
=IF(Lines!$Q$3:$Q$57="y",SUMIF(Lines!$I$3:$I$57,"=0",Lines!$F$3:$F$57),0)
For some reason it will calculate the first formula, but not the second when
i paste it to another column. i
don't understand why it works for one and not the other...any ideas?
=IF(P3>0,"Y","N")
I then used the following function:
=IF(Lines!$Q$3:$Q$57="n",SUMIF(Lines!$I$3:$I$57,"=0",Lines!$F$3:$F$57),0)
i repeated the function for "y":
=IF(Lines!$Q$3:$Q$57="y",SUMIF(Lines!$I$3:$I$57,"=0",Lines!$F$3:$F$57),0)
For some reason it will calculate the first formula, but not the second when
i paste it to another column. i
don't understand why it works for one and not the other...any ideas?