how do I ignore certain lines

[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

 

[Dave Peterson]

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.

 

[Pete_UK]

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

 

[jon]

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

 

[Dave Peterson]

=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.

 

[jon]

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

 

[Dave Peterson]

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

 

[Dave Peterson]

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.