+ Reply to Thread
Results 1 to 5 of 5

Multiply selective criteria

  1. 10-20-2013, 04:34 AM #1
    ryan4646
    ryan4646 is offline
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    134

    Question Multiply selective criteria

    HI,

    I have some sheets of over time. I want to multiply all the 10 hours with 2 ( 10*2) not 8 hours. Can any help me with a formula to calculate only 10 hrs with 2 in the yellow marks?

    I know the sheets is small that I can calculate by hand, but I have so much bigger ships.
    Attached Files Attached Files
    thanks,

    Ryan
    Reply With QuoteRegister To Reply
  2. 10-20-2013, 04:43 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Multiply selective criteria

    Hi,

    =COUNTIF(B4:M4,10)*20

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 10-20-2013, 05:00 AM #3
    ryan4646
    ryan4646 is offline
    Forum Contributor ryan4646's Avatar
    Join Date
    06-10-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003, 2007
    Posts
    134

    Re: Multiply selective criteria

    done and thanks.
    Reply With QuoteRegister To Reply
  4. 10-20-2013, 07:03 AM #4
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Multiply selective criteria

    You're welcome.
    Reply With QuoteRegister To Reply
  5. 10-20-2013, 07:06 AM #5
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Multiply selective criteria

    Also,

    =SUMIF(B4:M4,10)*2
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    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. [SOLVED] If two criteria’s are met, then multiply these cells
    By dbgmpa8 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-05-2013, 05:13 PM
  2. 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
  3. Sum by criteria in order to multiply
    By The student in forum Excel General
    Replies: 3
    Last Post: 06-08-2012, 08:16 PM
  4. 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
  5. Multiply COUNTIF by criteria in same row.
    By Belfast_stu in forum Excel General
    Replies: 11
    Last Post: 02-10-2011, 05:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1