+ Reply to Thread
Results 1 to 1 of 1

SUMPRODUCT using WORKSHEET FUNCTION

  1. #1
    Forum Contributor codeslizer's Avatar
    Join Date
    05-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    245

    SUMPRODUCT using WORKSHEET FUNCTION

    Hey Guys,

    Attached is the sample file of my work. Basically am trying to analyse on surveys and have been using custom formulae to get my results. In this sample, I have varying records (rows) of surveys, varying conditions on rows, and even the varying columns from where I need to collate the ratings of those surveys. I have created the formulae. But now as they are SUMPRODUCT, I would like to implement it via WORKSHEET FUNCTION in VBA (as SUMPRODUCTs sucks up good amount of memories). Why..? basically, I have thousands and thousands of rows through which I need to get my solutions it takes hell lot of time in Cell calculations so need to make it just fixed values and would put the formulae only when we need to make a calculation.

    Need assistance to perform the same operation using WORKSHEET FUNCTION and not FormulaR1C1 / Formula. The reason is because there will be dynamic movements of columns or maybe additions - So need the function to perform operations - based only on the parameters that I supply to them.
    Attached Files Attached Files
    cOdEsLiZeR - Back after a long break.. Let's sLiZe some more cOdEs!!

+ 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. Replies: 9
    Last Post: 07-02-2012, 07:02 PM
  2. Replies: 10
    Last Post: 11-11-2010, 03:49 PM
  3. Using SumProduct Worksheet Function in VBA
    By jasoncw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2009, 05:24 PM
  4. [SOLVED] Sumproduct from different worksheet
    By roy.okinawa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2006, 12:55 AM
  5. SUMIF Function Inside SUMPRODUCT Function
    By Abdul Waheed in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-19-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1