Adding time

[Guest]

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.

 

[Guest]

Try

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

 

[Guest]

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.

 

[Ragdyer]

Try this:

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

 

[Guest]

Hello Ragdyer

Ragdyer using your formula 1 get 7:30

Adding minus I get 9:29 and adding Plus I get 22:01 the totalling answer
should be 31:30

Ragdyer What is the I'm not doind correctly please

Thankyou.

 

[Bob Phillips]

Format the result cell as [h]:mm

--
HTH

Bob

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

 

[Bob Phillips]

Why not just

=SUM(F1:F104)

--
HTH

Bob

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

 

[Guest]

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.

 

[Ragdyer]

See last line of OP's 2nd post.<g>

 

[Guest]

I thankyou all.

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

 

[Ragdyer]

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>

 

[Bob Phillips]

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]

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 !
-----------------------------------------------------------------------------------------------

See, you make it too complex <vbg>

--
HTH

Bob

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

 

[Bob Phillips]

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)