+ Reply to Thread
Results 1 to 3 of 3

Multiply two columns and then sum based on multiple sheet in the same column

  1. #1
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    387

    Multiply two columns and then sum based on multiple sheet in the same column

    Hi,
    I have workbook with 10 worksheet (Day1,Day2,Day3.....Day9,Day10) and 1 Sheet "Summary".

    I need formula which Multiply two columns and then sum in "Summary" Sheet based on multiple sheet in the same column.

    Thanks.
    My English is very poor, so please be patient >_<"

    Thanks & Regards.
    hkbhansali

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Multiply two columns and then sum based on multiple sheet in the same column

    I feel that the multiplication could be done in each "Day" sheet individually then the sum calculated on the "Summary" sheet.
    It may help if you attach a sample workbook as per the instructions in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Multiply two columns and then sum based on multiple sheet in the same column

    Have you considered keeping all your daily data on a single sheet with an extra column to identify the day?

    It seems to me that would be a lot more flexible and simplify any analysis, and of course you open up the stnadard Pivot Table functionality
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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] Split one excel sheet into multiple sheets based on column value but only selected columns
    By nr6281 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-01-2019, 05:25 AM
  2. Replies: 4
    Last Post: 10-20-2016, 09:55 PM
  3. Replies: 1
    Last Post: 10-20-2016, 09:51 PM
  4. [SOLVED] multiply column values based on multiple criteria
    By Yokosuka in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-03-2016, 01:55 PM
  5. [SOLVED] select entire column based on activecell - multiply cells based if found empty cell
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-08-2016, 01:52 AM
  6. Feeding multiple columns from one sheet into another while combining totals based 2 column
    By BabyBair0708 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2015, 07:01 PM
  7. [SOLVED] Can you multiply different columns based on information in another column?
    By Yamaha Rider in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2014, 02: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