Results 1 to 9 of 9

How to use minus formula in sumproduct

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    30

    How to use minus formula in sumproduct

    Hello All,

    I want to minus negative score from total score. Example:

    Let's take one positive survey will give 100% score and one negative survey gives 0% score. If we get 10 surveys out of which 9 are positive and 1 is negative, so the score will be 90%.

    A11=100%, A12=0%
    B11=9, B12=1

    The formula is =sumproduct(A11:A12*B11:B12)/sum(B11:B12)

    Now I want to remove that one negative survey from the total score of 90% using sumproduct formula. Please help!!

    Attached is the file for better understanding.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Swits leading minus and put minus infront of numbers without macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2015, 11:40 AM
  2. [SOLVED] Help to amend sumproduct formula to minus depending on entry in another column
    By KELLIS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2013, 02:15 PM
  3. SUMPRODUCT with ID numbers that has minus signs and using time as an array...
    By excellenthelp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2013, 01:26 PM
  4. [SOLVED] SUMPRODUCT formula to find name/date & value then minus from value in another cell
    By SChapman in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-17-2013, 03:32 AM
  5. [SOLVED] I neeed help on changing a minus figure so it does not show a minus
    By Kirstg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2012, 11:44 AM
  6. change plus/minus inside a sumproduct function
    By orang in forum Excel General
    Replies: 1
    Last Post: 09-28-2006, 08:54 AM
  7. [SOLVED] CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
    By Socal Analyst looking for help in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 02:20 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