how do I ignore certain lines

  • Thread starter Thread starter jon
  • Start date Start date
J

jon

Hi
I have a list of times and figures I add up and average for my bike riding
but the odd line I want to ignore for certain reasons.

Not to sure what to use but I have column b and if I want to ignore this
line I want to put a "y" in it.
The sheet is synced with a PDA so the commands have to work on excel mobile.
I know sumproduct does not work on the PDA, any advise is welcome.



Thanks
Jon
 
Do =sumif() and =countif() work on your PDA?

If not how about just using another column:

=if(b1="y","skip",a1)

=average() in excel will ignore the cells with text in them.
 
Your description is a bit vague, but depending on what you want to do
you might be able to use SUMIF - is this available on your PDA?

Hope this helps.

Pete
 
Hi
tried sumif (b8:b150,"y",K8:k150)
but this only selects the ones with y in the b Colum. and it wont let me put
<> in the formula.
another sum I use is min(a8:a150) and avg() max() etc.
Any idea how I can use these with the ability of ignoring certain rows?

Thanks

Jon
 
=sumif(b8:b150,"<>y",K8:k150)

Before you continue with the others, I'd try the =sumif() on the PDA.

And even then, if you can't use array formulas, I'd just use the extra column.
 
Hi Dave
the sum if works on the PDA .
I had it wrong, I( had put =sumif(b8:b150,<>"y",K8:k150)

any Idea how to do the other functions?

Thanks

Jon
 
Any suggestions I would have would include array formulas.

But maybe the PDA includes =averageif() or =maxif().


Hi Dave
the sum if works on the PDA .
I had it wrong, I( had put =sumif(b8:b150,<>"y",K8:k150)

any Idea how to do the other functions?

Thanks

Jon
Click to expand...
 
In fact, if you're using xl2007, you may want to look at excel's help. They
added some (not all) of these =xxxxIF() functions.
 
Back
Top