+ Reply to Thread
Results 1 to 2 of 2

Possible??? - Multiply Individually, then Sum, for an entire Range

  1. #1
    Registered User
    Join Date
    01-21-2025
    Location
    Memphis, TN
    MS-Off Ver
    2016
    Posts
    1

    Question Possible??? - Multiply Individually, then Sum, for an entire Range

    Hello,
    I am trying to build a spreadsheet to track inventory at a consignment store. I've attached a picture of my spreadsheet for visual reference.
    At the far right, I am able to total the revenue I receive (70%) for each item in the row, and then get the sum total for the whole column at the top in row 1
    I would like to calculate my 70% total for each month so that I can easily roll that into my master summary spreadsheet.
    To do this, I would need to multiply (for October) N4*$C4 for each row, and then sum those totals.
    I could insert a new column for each month to achieve this, but i was hoping there was a formulaic way to do this so I could have the 70% revenue total at the top above each month, without having to add extra columns.

    While there are only 12 different items right now, the list will grow, so i dont want to have to manually add each calculation.
    (N4*$C4)+(N5*$C5)+(N6*$C6)+(N7*$C7)+(etc etc)
    Is there a formula that can multiply the range in column N by the cells in column C for the same row, and the Sum them, without me having to manually write out?

    Screenshot 2025-01-21 143202.png
    Last edited by kruth27; 01-21-2025 at 11:05 PM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,454

    Re: Possible??? - Multiply Individually, then Sum, for an entire Range

    If I understand, that looks exactly like a SUMPRODUCT() function: https://support.microsoft.com/en-us/...c-4d2145a2fd2e =SUMPRODUCT(N4:N40,$C4:$C40)
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] For each cell... look at a range of cells not individually
    By terratushi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-30-2017, 12:31 PM
  2. Macro to multiply entire row by a fix given number
    By buchumang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2014, 04:33 PM
  3. Replies: 3
    Last Post: 04-06-2012, 02:25 PM
  4. macro to sum each range individually within a single column
    By jferguson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-16-2010, 12:56 PM
  5. how do i multiply entire columns of numbers by a %
    By stgaw53 in forum Excel General
    Replies: 1
    Last Post: 10-26-2005, 02:05 PM
  6. [SOLVED] how do I divide or multiply an entire column?
    By 1number in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2005, 05:07 PM
  7. multiply entire column by a number
    By ludarabota in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-03-2005, 02:55 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1