+ Reply to Thread
Results 1 to 8 of 8

Need a macro instead of SUMIF & COUNTIFS formula

  1. 07-29-2013, 05:28 AM #1
    Keyvan
    Keyvan is offline
    Registered User
    Join Date
    05-28-2012
    Location
    Tehran, Iran
    MS-Off Ver
    Excel 2007 , 2010
    Posts
    4

    Need a macro instead of SUMIF & COUNTIFS formula

    Hi
    I have 400 csv file that they are output of a program and now I need calculate something on them
    first of all I find a code to import all of my csv to an excel file
    then by using SUMIF and COUNTIF I calculate my needs But I Need to know if there are better way

    I Used Something like this
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    ExcelForum.xlsx
    and as you see in the attached file the output is not suitable for bigger file
    is there any better solution ?

    thank you in advanced
    Keyvan,
    Last edited by Keyvan; 07-29-2013 at 07:47 PM.
    Reply With QuoteRegister To Reply
  2. 07-29-2013, 06:23 AM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need a macro instead of SUMIF & COUNTIFS formula

    Maybe you could use Current Region and Offset to apply your formulas?

    Sample-
    Please Login or Register  to view this content.











    sw
    Reply With QuoteRegister To Reply
  3. 07-29-2013, 08:27 AM #3
    Keyvan
    Keyvan is offline
    Registered User
    Join Date
    05-28-2012
    Location
    Tehran, Iran
    MS-Off Ver
    Excel 2007 , 2010
    Posts
    4

    Re: Need a macro instead of SUMIF & COUNTIFS formula

    Thanks JOHN

    in fact I have a sheet with More than 2000 Columns and I need to run 3 formulas for every 5 columns based on values of first cell's of each row (status)
    I tried to use this code 

    Please Login or Register  to view this content.
    But I get this error

    Run-time error '1004':
    Method 'Range' of Object '_Global' failed
    Reply With QuoteRegister To Reply
  4. 07-29-2013, 04:10 PM #4
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need a macro instead of SUMIF & COUNTIFS formula

    Hi Keyvan

    It's not apparent to me what you wish to SUM nor where you wish to put it but you'll need this kind of Code. Perhaps this'll get you started. 
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  5. 07-29-2013, 07:47 PM #5
    Keyvan
    Keyvan is offline
    Registered User
    Join Date
    05-28-2012
    Location
    Tehran, Iran
    MS-Off Ver
    Excel 2007 , 2010
    Posts
    4

    Re: Need a macro instead of SUMIF & COUNTIFS formula

    Hi Jalaske

    Thank you very much, It's exactly what I want
    Reply With QuoteRegister To Reply
  6. 07-29-2013, 07:50 PM #6
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need a macro instead of SUMIF & COUNTIFS formula

    You're welcome...glad I could help. Thanks for the Rep.
    Reply With QuoteRegister To Reply
  7. 07-29-2013, 08:19 PM #7
    Keyvan
    Keyvan is offline
    Registered User
    Join Date
    05-28-2012
    Location
    Tehran, Iran
    MS-Off Ver
    Excel 2007 , 2010
    Posts
    4

    Re: Need a macro instead of SUMIF & COUNTIFS formula

    You're welcome
    just another question
    could you please help me about this formula too ?!

    Please Login or Register  to view this content.
    Thank you again

    P.S. absolutely the firs part is enough
    Please Login or Register  to view this content.
    Edit : I think I solve it

    Please Login or Register  to view this content.
    Last edited by Keyvan; 07-29-2013 at 08:30 PM.
    Reply With QuoteRegister To Reply
  8. 07-30-2013, 01:26 PM #8
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need a macro instead of SUMIF & COUNTIFS formula

    Hi Keyvan

    Good for you
    Edit : I think I solve it
    You're welcome...glad I could help. Thanks for the Rep.
    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. Formula needed for countif or countifs (may also need a sumif)
    By Petefav in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 02:18 AM
  2. Sumif, sumifs, counta, countifs??
    By 1.zer0 in forum Excel General
    Replies: 3
    Last Post: 01-14-2012, 06:18 AM
  3. Macro to add range & criteria in COUNTIFS Formula
    By wspettus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2011, 03:34 AM
  4. Excel 2007 : More efficient: 2 long COUNTIFS or 1 COUNTIFS and 1 VLOOKUP based on the COUNTIFS?
    By dip11 in forum Excel General
    Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  5. converting COUNTIFS formula to macro
    By batjl9 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-14-2011, 03:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1