Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
strange error
i used an "IF" function to make a column Q of "y" and "n" entries, as such:
=IF(P30,"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. i don't understand why it works for one and not the other...any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
strange error
It is working fine for me...
Go to tools | options | calculation tab | check the automatic radio button on ? On Apr 1, 10:13*pm, martinbarnes wrote: i used an "IF" function to make a column Q of "y" and "n" entries, as such: =IF(P30,"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. *i don't understand why it works for one and not the other...any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
strange error
it's still not working for me...and it's driving me crazy. thanks for
responding.... "muddan madhu" wrote: It is working fine for me... Go to tools | options | calculation tab | check the automatic radio button on ? On Apr 1, 10:13 pm, martinbarnes wrote: i used an "IF" function to make a column Q of "y" and "n" entries, as such: =IF(P30,"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. i don't understand why it works for one and not the other...any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
strange error
What did you want this to mean?
=if(Lines!$Q$3:$Q$57="n", ... Did you want all the cells in Q3:Q57 to be n or at least one? Maybe you could use =if(countif(lines!$q$3:$q$57,"n")=55, ... or =if(countif(lines!$q$3:$q$57,"n")0, ... martinbarnes wrote: i used an "IF" function to make a column Q of "y" and "n" entries, as such: =IF(P30,"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. i don't understand why it works for one and not the other...any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange error | Excel Worksheet Functions | |||
Strange error | Setting up and Configuration of Excel | |||
Very strange error | Excel Discussion (Misc queries) | |||
strange error on saving | Excel Discussion (Misc queries) | |||
Strange Error Message | Excel Discussion (Misc queries) |