+ Reply to Thread
Results 1 to 3 of 3

Sumproduct Alternative

  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    657

    Sumproduct Alternative

    I have Worksheet("Sheet1") that has roughly 300,000 rows
    and Worksheet("Totals") that has 2,400 rows

    Sheet1 has transactions 1 to a line with company (Column D) Revenue (Column R) and Cost (Column S)

    Some companies have more than one name such as: Law office of Jones / Jones LLC
    I have arranged the multiples in adjacent columns (E,F,J etc...)

    Most Companies have one name - some schools have multiple names

    Currently I have:
    Please Login or Register  to view this content.
    in Column B and
    Please Login or Register  to view this content.
    in column C
    Copied down through row 2,400

    This kills my computer

    What macro would you suggest that would quickly determine if a cell is empty, find and sum the instances on sheet1, then move on?

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: Sumproduct Alternative

    Have you tried a Pivot Table?

  3. #3
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    657

    Re: Sumproduct Alternative

    names don't match so it would be no good.
    I need to sum the cost of Law office of Jones & Jones LLC - Pivot table would keep them separate.
    that is why my sumproduct has $E2:$Z2 so all possible names can be listed - then looked up and summed from sheet1

+ 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. Alternative to SUMPRODUCT???
    By VTdude12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2011, 04:03 PM
  2. Alternative to SUMPRODUCT?
    By cjrhoads in forum Excel General
    Replies: 26
    Last Post: 05-14-2010, 03:32 PM
  3. Sumproduct alternative
    By DKerr in forum Excel General
    Replies: 6
    Last Post: 01-09-2009, 11:25 AM
  4. Sumproduct - Alternative
    By Harlequin in forum Excel General
    Replies: 2
    Last Post: 08-09-2007, 12:52 PM
  5. Alternative to SUMPRODUCT?
    By staeri@gmail.com in forum Excel General
    Replies: 1
    Last Post: 06-09-2006, 07:10 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