strange error

  • Thread starter Thread starter martinbarnes
  • Start date Start date
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. i
don't understand why it works for one and not the other...any ideas?
 
It is working fine for me...

Go to tools | options | calculation tab | check the automatic radio
button on ?
 
it's still not working for me...and it's driving me crazy. thanks for
responding....
 
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, ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top