Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Posts
    63
    Thanks
    6
    Thanked 0 Times in 0 Posts

    SUMIF the criterion contains a specified substring

    Using SUMIF, I want to sum all items where the criterion cell contains a specified substring (say, "Feb"). I tried specifying "*Feb*", but that seems to work only if the "Feb" is at the start of the criterion string. Does this make sense? Any ideas?

    Thanks

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts

    SUMIF with wild card

    Wild card works. Perhaps your dates are being interpreted as 2/1/2013. Use an underscore instead of a hyphen if applicable.
    =SUMIF(A2:A6,"*Feb*",B2:B6)

    sumif.jpg

    HTH,
    Maud
    Last edited by Maudibe; 2013-02-02 at 22:06.

  3. #3
    Star Lounger
    Join Date
    Mar 2006
    Posts
    63
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Works ,this time, thanks. Don't know what I was doing wrong last time, but I'm now full steam ahead. 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
  •