+ Reply to Thread
Results 1 to 2 of 2

Conditionally Sum (via VBA)

  1. #1
    Registered User
    Join Date
    09-05-2006
    Posts
    1

    Conditionally Sum (via VBA)

    Dear all master,

    I am new to this forum.

    While I am currently trying to write VBA code on an Excel spreadsheet with >65,000 rows and over 30 columns.

    On one column, which I previously use 'SumIf' on the sheet for calculation on one column, it takes me 1 hour just to drag and for Excel to calculate those values.

    As such, I am thinking if I can write a piece of code to handle the similiar calculation and perform calculation much faster.

    My set up could be like this:

    Col A Col B ($) Col C (Result)
    A 1 14
    A 2 14
    A 3 14
    B 4 9
    B 5 9
    C 6 6
    D 7 7
    A 8 14

    I tried to use For loop to handle this, but without success....cos I always get duplicated result at Col C.

    Would very much appreciate if any master could assist me. Thousand of thanks ahead.

    Kind regards,

    Joseph
    Last edited by jtcl; 09-05-2006 at 12:46 PM.

  2. #2
    Forum Contributor
    Join Date
    08-19-2006
    Posts
    116
    Dear all alone,

    I didn't understand what you want to do. What is the link between the columns? I can see the serie in the column B (1,2,3....). ButI do not see the arithmetic progression in the first column :A,A,A and B,B? I see when the same value is written in the third column (C), you have the same value in the first column: A,A,A /14,14,14.
    After I do not follow. If you want some help, please give more points.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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