Results 1 to 3 of 3

Thread: Cell contails specific text
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2010
    Posts
    453
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Cell contails specific text

    =IF(E38="Blue",(SUMIFS(F38:X38, F39:X39, "")), "0")

    Hi all

    I use the above formula to sum row 38 when the row belows cell are blank , can I change that condition to ONLY sum if cell DOES NOT contain a * ?

    Is that possible with this formula?

    Thanks
    A

  2. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,089
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Cell contails specific text

    Hi, you could try like this:

    =IF(E38="Blue",SUMIFS(F38:X38, F39:X39, "<>*~**"), 0)
    Last edited by FormR; Sep 4th, 2019 at 05:03 AM.
    [code]your code[/code]

  3. #3
    Board Regular
    Join Date
    Oct 2010
    Posts
    453
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cell contails specific text

    Quote Originally Posted by FormR View Post
    Hi, you could try like this:

    =IF(E38="Blue",SUMIFS(F38:X38, F39:X39, "<>*~**"), 0)
    Perfect works
    thanks so much

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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