+ Reply to Thread
Results 1 to 2 of 2

How can I adapt multiple SUMPRODUCT formula into single formula?

  1. #1
    Registered User
    Join Date
    02-24-2019
    Location
    UK
    MS-Off Ver
    Mac 365
    Posts
    79

    How can I adapt multiple SUMPRODUCT formula into single formula?

    I am looking for some help to develop a SUMPRODUCT formula.

    I have a couple of conditions set, assuming the conditions are met I essentially want to count how many cells are greater than another within the same column.

    So far I follow methodology to compare All rows that meet condition to 1st row, then all rows that meet condition to 2nd row, then all rows that meet condition to 3rd row and all rows that meet condition to 4th row. I achieve this with 4 separate SUMPRODUCT formula.

    I want to get the sum of these four SUMPRODUCT formula but without simply adding them together. My target project involves hundreds of rows and columns so this would not be practical.

    I attach an example of where I have gotten to so far, i.e. I have the end result I want but I am using 4 SUMPRODUCT formula and then summing them, ideally looking to achieve this with one single formula (if it is even possible), failing that I guess I revert to using helper column (as per attached example) and sum that.

    Below are the formula I currently use
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For this project I am using Mac Excel.

    Any help/ideas would be gratefully received.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,810

    Re: How can I adapt multiple SUMPRODUCT formula into single formula?

    Please take a moment to update your profile. It does not show the Excel version that you are using.
    Glenn



+ 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. [SOLVED] How to combine the multiple SUMPRODUCT into a single formula
    By billj in forum Excel General
    Replies: 3
    Last Post: 12-23-2019, 04:38 AM
  2. [SOLVED] SUMIFS / SUMPRODUCT / Multiplication and addition in single cell formula (help required)
    By KashifNawaz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-11-2019, 04:13 AM
  3. Adapt formula to search multiple columns on different sheets
    By GPetcu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2017, 03:30 AM
  4. Display Single Value for Multiple Outcomes of a Sumproduct formula
    By robshak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2016, 09:24 AM
  5. Replies: 5
    Last Post: 06-10-2014, 10:09 PM
  6. Replies: 2
    Last Post: 05-22-2014, 04:14 AM
  7. Single cell array or sumproduct formula
    By BRISBANEBOB in forum Excel General
    Replies: 4
    Last Post: 06-16-2009, 06:25 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