Results 1 to 10 of 10
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I started a post yesterday regarding summing a column of numbers (Column but only if certain text was in column A. However, I can't find the post, and, unfortunately, I deleted the formula inadvertantly before saving it. I believe Hans answered the query. Any help on finding the post? Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by jlkirk View Post
    I started a post yesterday regarding summing a column of numbers (Column but only if certain text was in column A. However, I can't find the post, and, unfortunately, I deleted the formula inadvertantly before saving it. I believe Hans answered the query. Any help on finding the post? Thanks.
    Click on your name to bring up your profile, then click on the 'Find threads' or 'Find posts' links under your picture.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Did you mean this one?
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The thread has disappeared - perhaps a moderator or administrator can shed light on this.

    The formula was =IF(ISERROR(FIND("Red",A1)),"",B1)


  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Quote Originally Posted by rory View Post
    Did you mean this one?
    Jeff posted a thread with subject SUMIF here in the Lounge, and I posted a reply, but the thread is gone.

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Quote Originally Posted by rory View Post
    Yes. So what happened? Had it been hidden, or deleted?

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Just hidden, as far as I can tell. (I don't think I could retrieve it if it had been deleted) Not sure why (but then I'm still trying to figure a lot of stuff out after the upgrade!)
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Thanks!


  10. #10
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    Just hidden, as far as I can tell. (I don't think I could retrieve it if it had been deleted) Not sure why (but then I'm still trying to figure a lot of stuff out after the upgrade!)
    Thanks.

Posting Permissions

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