Thread: Adding time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default Adding time

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.