Maybe...

Maybe you have a list separator of semicolon (;) instead of comma (,).

Try changing the formula to:
=SUMIF(A1:A12;"0";A1:A12)
(same kind of thing with the other formulas, too)

===
If that's not it, I think you're going to have to explain what you mean.

Can you enter the formula?
Does it evaluate incorrectly?


Kitty wrote:

On Tue, 10 Oct 2006 13:31:38 GMT, Kitty wrote:

Hi and thanks but I can't get it to work :( I think it maight have to
do with the syntax somehow I'm on a international pc with an english
version of excel 2003

I have made a fresh new file with the follwing numbers

Column <A
7,11
-0,52
13,47
12,72
-9,21
1,95
2,71
-1,95
15,45
7,85
-11,34
-12,39

This formula =SUM(A1:A12) works and gives the result
of 25,85 Note the comma as separator.

I can also do this =AVERAGE(A1:A12) which gives 2,15

But I can't do this =SUMIF(A1:A12,"0",A1:A12) "the formula you
typed...

=AVERAGE(IF(A1:A12<0,A1:A12)) also no good :(

Any ideas - Thanks

--

Dave Peterson