I have a set of numbers both positive & negative when I use sum I get
one answer when I use sumif I get another....

-14.93
-10.56
5.66
4.56
30.56
-35.60
-3.54
-19.28
-34.79
-0.48
-19.57
17.55
77.02
-10.62
-1.66
-1.00
-15.25
0.31
-14.35
7.67

Using sum I get -38.32, but when I use sumif I get -29.20...

Can anyone explain this and give a solution on how to correct??



Hans

Post the formulas you're using.
--
Brevity is the soul of wit.


" wrote:

I have a set of numbers both positive & negative when I use sum I get
one answer when I use sumif I get another....

-14.93
-10.56
5.66
4.56
30.56
-35.60
-3.54
-19.28
-34.79
-0.48
-19.57
17.55
77.02
-10.62
-1.66
-1.00
-15.25
0.31
-14.35
7.67

Using sum I get -38.32, but when I use sumif I get -29.20...

Can anyone explain this and give a solution on how to correct??



Hans

On 24 Jan 2007 11:58:32 -0800, "
wrote:

I have a set of numbers both positive & negative when I use sum I get
one answer when I use sumif I get another....

-14.93
-10.56
5.66
4.56
30.56
-35.60
-3.54
-19.28
-34.79
-0.48
-19.57
17.55
77.02
-10.62
-1.66
-1.00
-15.25
0.31
-14.35
7.67

Using sum I get -38.32, but when I use sumif I get -29.20...

Can anyone explain this and give a solution on how to correct??



Hans


What criteria are you using in your SUMIF formula?
--ron

Dave and Ron sorry that you responded already....I found my issue it is
called USER ERROR!!!


Thanks Guys


Hans

On Jan 24, 3:20 pm, Ron Rosenfeld wrote:
On 24 Jan 2007 11:58:32 -0800, "
wrote:





I have a set of numbers both positive & negative when I use sum I get
one answer when I use sumif I get another....

-14.93
-10.56
5.66
4.56
30.56
-35.60
-3.54
-19.28
-34.79
-0.48
-19.57
17.55
77.02
-10.62
-1.66
-1.00
-15.25
0.31
-14.35
7.67

Using sum I get -38.32, but when I use sumif I get -29.20...

Can anyone explain this and give a solution on how to correct??

HansWhat criteria are you using in your SUMIF formula?
--ron- Hide quoted text -- Show quoted text -