+ Reply to Thread
Results 1 to 2 of 2

Need to product based on a criteria and then want to sum the whole range

  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    Need to product based on a criteria and then want to sum the whole range

    Hi Team,

    I have a requirement where I want to product two columns based on a Name criteria and the criteria is "NA".It will multiply only when NA is found in Name.

    e.g:Apr-18 col of Overall capcity will be multiplied by Apr-18 column of D&P.Finally I want the total sum and that will be revenue monthwise.Sample sheet attached.

    Regards,
    Aps
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: Need to product based on a criteria and then want to sum the whole range

    In C14

    =SUMPRODUCT(($B$3:$B$12="NA")*(C$3:C$12)*(I$3:I$12))

    Copy across

+ 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] SUM PRODUCT: Ranking a Cell based on Criteria
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2014, 02:54 PM
  2. [SOLVED] SUM PRODUCT: Ranking a Cell based on Criteria
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-24-2014, 07:07 AM
  3. Flagging different product based on 1 range
    By mmmarshman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-25-2013, 12:52 PM
  4. [SOLVED] SUMPRODUCT from a DATE RANGE based upon a product and static number
    By mmayna03 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-14-2013, 10:33 AM
  5. multiple column sum product based on set criteria
    By b16dlg in forum Excel General
    Replies: 4
    Last Post: 07-11-2012, 07:51 AM
  6. Replies: 1
    Last Post: 01-14-2012, 12:00 PM
  7. [SOLVED] Product of 2 arrays based on criteria
    By Ben010 in forum Excel General
    Replies: 4
    Last Post: 03-20-2006, 03:55 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