+ Reply to Thread
Results 1 to 10 of 10

Multiply based on criteria

Hybrid View

  1. 08-29-2015, 08:46 AM #1
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    Re: Multiply based on criteria

    Formula: copy to clipboard 
    =PRODUCT(IF(A1:A5="Blue",B1:B5)

    This is an array formula.

    [Ctrl + Shift + Enter] to make it work.
    Attached Images Attached Images
    Last edited by davesexcel; 08-29-2015 at 08:51 AM.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. autofilter with multiply criteria
    By ccsmith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2015, 12:53 PM
  2. Multiply rows based on Multiple Criteria
    By chacha123 in forum Excel General
    Replies: 3
    Last Post: 02-12-2015, 09:09 AM
  3. If criteria match, multiply then sum across multiply worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 02:20 PM
  4. Multiply based on multiple array criteria
    By jcullen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2012, 06:14 PM
  5. how do i multiply based on 2 column criteria?
    By gjjh25 in forum Excel General
    Replies: 3
    Last Post: 11-24-2011, 09:58 AM
  6. Multiply COUNTIF by criteria in same row.
    By Belfast_stu in forum Excel General
    Replies: 11
    Last Post: 02-10-2011, 05:30 PM
  7. Excel 2007 : Multiply a value based on a certain date criteria
    By channguyen in forum Excel General
    Replies: 1
    Last Post: 06-25-2010, 02:39 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1