+ Reply to Thread
Results 1 to 5 of 5

Multiple Range of Cells by a number

  1. 11-28-2017, 10:25 AM #1
    duccman
    duccman is offline
    Registered User
    Join Date
    11-28-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    2

    Multiple Range of Cells by a number

    I want to multiply numbers in column B by 3. But I want the total to only show in C-2, How do I do this ?

    Thanks in advance
    Duccman
    Reply With QuoteRegister To Reply
  2. 11-28-2017, 10:28 AM #2
    JohnTopley
    JohnTopley is offline
    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,359

    Re: Multiple Range of Cells by a number

    =sumproduct(b1:b3*3)

    or simply (better)

    =sum(B1:b10)*3
    Last edited by JohnTopley; 11-28-2017 at 10:33 AM.
    Reply With QuoteRegister To Reply
  3. 11-28-2017, 10:29 AM #3
    than_gold
    than_gold is offline
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Multiple Range of Cells by a number

    You can try this in C2

    =SUM(B:B)*3
    Regards,
    Thangavel D
    Appreciate the help? CLICK *
    Reply With QuoteRegister To Reply
  4. 11-28-2017, 10:32 AM #4
    duccman
    duccman is offline
    Registered User
    Join Date
    11-28-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    2

    Re: Multiple Range of Cells by a number

    Thank you my new Excel family !!!
    Reply With QuoteRegister To Reply
  5. 11-28-2017, 10:35 AM #5
    than_gold
    than_gold is offline
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Multiple Range of Cells by a number

    Happy to assist you. You can click "Add Reputation" if you find we help you!!!
    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. Want to multiply a range of cells by one number but I want to exclude the highest number
    By jameshealy19 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2015, 12:30 PM
  2. [SOLVED] Count number of cells in range since last number greater than zero
    By whitfieldcraig in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2015, 06:38 AM
  3. [SOLVED] Trim Range of Cells FIRST then Count the number of blank cells
    By Jim28 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2013, 04:08 AM
  4. [SOLVED] Select range of multiple cells with variable row number
    By Phiabell in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-07-2013, 10:34 AM
  5. Count Specific Number Across Range Of Cells Across Multiple Tabs
    By PacE in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2012, 09:43 AM
  6. Finding a number in multiple cells with each of its own range
    By mmm213 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-14-2009, 06:46 PM
  7. INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell
    By Tourcat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2005, 03:06 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