+ Reply to Thread
Results 1 to 10 of 10

sumif in VBA

Hybrid View

lu fim sumif in VBA 07-04-2016, 08:40 AM
6StringJazzer Re: sumif in VBA 07-04-2016, 08:47 AM
lu fim Re: sumif in VBA 07-04-2016, 08:51 AM
lu fim Re: sumif in VBA 07-04-2016, 08:48 AM
6StringJazzer Re: sumif in VBA 07-04-2016, 09:24 AM
lu fim Re: sumif in VBA 07-04-2016, 09:45 AM
bakerman2 Re: sumif in VBA 07-04-2016, 10:25 AM
lu fim Re: sumif in VBA 07-04-2016, 10:57 AM
6StringJazzer Re: sumif in VBA 07-04-2016, 12:17 PM
lu fim Re: sumif in VBA 07-04-2016, 01:00 PM
  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,009

    Re: sumif in VBA

    On the right side you are missing a close quote and a close paren, and the left side the quote is in the wrong place:

     Range("G" & rw).Value = Application.WorksheetFunction.SumIfs(range("N:N"),Range("C" & rw),Range("S:S"))
    Last edited by 6StringJazzer; 07-04-2016 at 08:49 AM. Reason: Kept finding more code errors after the original post
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Registered User
    Join Date
    06-21-2016
    Location
    Brazil
    MS-Off Ver
    2002
    Posts
    23

    Re: sumif in VBA

    I fixted it, but it is giving me error '438' - object doesn't support this property or method

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SumIf formula or Sumif with pivottable combined question
    By mcgleeuw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2015, 01:05 PM
  2. Replies: 4
    Last Post: 12-04-2014, 02:06 PM
  3. Subtracting from the SUMIF with the difference from the SUMIF range
    By iamblue91 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2014, 09:01 PM
  4. [SOLVED] sumif i know , sumif with fix cell i dont know
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2014, 04:22 PM
  5. [SOLVED] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  6. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  7. Nested SUMIF statement or multiple SUMIF's
    By Dan27 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2009, 06:55 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1