+ Reply to Thread
Results 1 to 3 of 3

VBA Sumif does not equal text

  1. 04-21-2016, 10:36 AM #1
    milo1984
    milo1984 is offline
    Forum Contributor
    Join Date
    08-20-2012
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    184

    VBA Sumif does not equal text

    Hi,

    Trying to use SUMIFin VBA.

    [CODE][/Cells(15, 7).Value = Application.SumIf(Range("D23:D72"), "<>""Text A""", Range("K23:K72"))CODE]

    Unfortunately, this is not working. Any ideas how to include the <> correctly?

    Best Regards and Many thanks in advance
    Reply With QuoteRegister To Reply
  2. 04-21-2016, 10:50 AM #2
    walruseggman
    walruseggman is offline
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: VBA Sumif does not equal text 

    Please Login or Register  to view this content.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
    Reply With QuoteRegister To Reply
  3. 04-21-2016, 10:52 AM #3
    ptmuldoon
    ptmuldoon is offline
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Re: VBA Sumif does not equal text

    You have one to many set of quotes. Try

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to sumif date is less than or equal to
    By jgomez in forum Excel General
    Replies: 10
    Last Post: 07-24-2018, 10:18 PM
  2. not equal to formula in sumif
    By annux08 in forum Excel General
    Replies: 2
    Last Post: 07-17-2015, 09:03 AM
  3. Count #s in One Range If Text In Another Range is Equal or Not Equal to Specific Text
    By MLCall in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2012, 12:30 PM
  4. SUMIF with greater than or equal to
    By Shooter66 in forum Excel General
    Replies: 4
    Last Post: 01-10-2012, 04:42 PM
  5. If these cells equal this one here, sumif! NOT
    By tecsbrain in forum Excel General
    Replies: 3
    Last Post: 02-20-2011, 12:58 PM
  6. sumif non-number not equal to cell X
    By c_george in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-07-2007, 04:44 PM
  7. sumif if cell does not equal #N/A
    By Micah in forum Excel General
    Replies: 1
    Last Post: 02-02-2006, 05:45 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1