=sumif() and =countif() aren't part of the Analysis Toolpak.

Kevin B wrote:

Click Tools and select ADD-INS and see if you have the Analysis Toolpack
running, if not click the checkbox to turn it on. The SUMIF and COUNTIF
should work once it's activated
--
Kevin Backmann

"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