Results 1 to 3 of 3
  1. #1
    carlos
    Guest

    Help please autosum

    I want to do a sum od d1 to d100 etc, but i want to IGNORE ALL OF THE ITEMS THAT ARE NEGATIVE.

    I guess I need an if statement that if item is <0.00 = 0.00 but cant see how to complete the formula.

    please help me

    thank you[img]/w3timages/icons/spook.gif[/img]

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Help please autosum

    =SUMIF(range,">=1")
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    carlos
    Guest

    Re: Help please autosum

    John thankyou for that. I was so near and yet so far away. Always comes down to quotemarks.[img]/w3timages/icons/shy.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •