+ Reply to Thread
Results 1 to 2 of 2

Add total in column of corresponding data

  1. 05-12-2021, 05:28 PM #1
    LOURIKA
    LOURIKA is offline
    Registered User
    Join Date
    10-19-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2016
    Posts
    10

    Add total in column of corresponding data

    Data is obtained from another source and pasted into an excel worksheet. I need a formula that reflects the total in the cell next to the corresponding year and code. If there is no data it must reflect a zero.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-12-2021, 06:26 PM #2
    mikeava
    mikeava is offline
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Add total in column of corresponding data

    Please see my file and let me know what you think.
    Let me know if you have any questions.
    Attached Files Attached Files
    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] Data Total for different column
    By kmaient in forum Excel General
    Replies: 7
    Last Post: 12-01-2022, 04:27 AM
  2. Data validation: copy the total figure from column B into the correct analysis column
    By CJW01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2019, 06:38 PM
  3. total a colum using data from another column
    By Duffey in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2005, 02:05 AM

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