Results 1 to 4 of 4

Sum Multiple Columns Alternate Rows on Condition Basis

Threaded View

sg2209 Sum Multiple Columns... 03-04-2021, 10:07 AM
Glenn Kennedy Re: Sum Multiple Columns... 03-04-2021, 12:55 PM
sg2209 Re: Sum Multiple Columns... 03-05-2021, 05:34 AM
sg2209 Re: Sum Multiple Columns... 03-05-2021, 05:46 AM
  1. #1
    Registered User
    Join Date
    01-07-2018
    Location
    INDIA
    MS-Off Ver
    2010
    Posts
    37

    Lightbulb Sum Multiple Columns Alternate Rows on Condition Basis

    Hi All,

    Not able to do it with any formula, please help me with the attached file

    in Sheet1 i have numbers for my analysts Date Wise

    and in Sheet 2 there is a total for analyst date wise
    For Example in Sheet there are 10 Categories i want to add on 02/01/2021 A touched how many task in all the categories and the total for 02/01/2021 for A should appear in sheett under 02/01/2021.

    Your help is appreciated



    Thank You
    Sachin
    Attached Files Attached Files
    Last edited by sg2209; 03-04-2021 at 10:09 AM. Reason: Could not see the attachment, Reattached

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct for alternate rows with multiple columns
    By chullan88 in forum Excel General
    Replies: 7
    Last Post: 02-13-2019, 06:56 AM
  2. Maximum Value of Alternate Columns/Rows
    By Ratna K. Sthapit in forum Excel General
    Replies: 3
    Last Post: 12-07-2017, 10:05 AM
  3. [SOLVED] Add rows in Alternate columns, divide by fixed rate per column.
    By jomili in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-12-2017, 06:46 PM
  4. Spliting rows into multiple rows on the basis on Quantities
    By mchawla9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2015, 02:03 PM
  5. Transpose 2 columns to multiple rows with one condition
    By bellone in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2011, 05:00 AM
  6. [SOLVED] SUM function for alternate columns/rows
    By all4excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2007, 07:54 AM
  7. Sum of alternate columns & rows
    By kumawat_s in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2007, 10:59 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1