Sum Issue Help!

H

hansjhamm

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
 
R

Ron Rosenfeld

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
Click to expand...


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

hansjhamm

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


Thanks Guys


Hans
 
Top