ExcelBanter - Sum Issue Help!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum Issue Help! (https://www.excelbanter.com/excel-discussion-misc-queries/127545-sum-issue-help.html)

Sum Issue Help!

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

Dave F

Sum Issue Help!

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

Ron Rosenfeld

Sum Issue Help!

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

[email protected]

Sum Issue Help!

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 -

All times are GMT +1. The time now is 03:07 PM.