I can only guess that the No Change items were all zero, otherwise it
couldn't work.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"RagDyeR" wrote in message
...
And this is one of the *rare* occasions that I read the *entire* post
before
responding!<g
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
See, you make it too complex <vbg

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Ragdyer" wrote in message
...
So, what you're saying, is that you want to add "Plus" and "Minus" *AND*
"No Change" ... all together.

You didn't say that at the beginning, did you?<bg

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steved" wrote in message
...
I thankyou all.

Sum(F1:F104) Did as you all had said, My brain today is very slow today.

"AKphidelt" wrote:

Not sure we are understanding your request. If G1:G104 has just Plus
and
Minus then a simple Sum(F1:F104) would work. Like Bob said.

"Steved" wrote:

Hello AKphidelt

Firstly I thankyou

Now I would like to take your formula pleas to one more stage please.

=SUMIF(G1:G104,"Plus",F1:F104)
=SUMIF(G1:G104,"Minus",F1:F104)

=SUMIF(G1:G104,"Plus","Minus",F1:F104)

My objective is to now add Column but the above is not working
What do I reqiure to do please to add the column using both "Plus"
and
"minus"
ps I have some rows with "No Change" in Column G1 to G104

Thankyou.

"AKphidelt" wrote:

Try

=SUMIF(G1:G104,"Plus",F1:F104)

"Steved" wrote:

Hello from Steved

I have in Column F1 to F104 times that I "SUM" which is ok.

Now for my issue and that is some off the time is Plus and some
are Minus
I have the labels "Plus" and "Minus" in Column G1 to G104.

My question please is That I want to add the "Plus" only
How do I acheive this please.

Thankyou.