+ Reply to Thread
Results 1 to 2 of 2

Excel Programming help need to find multiple averages and sums

  1. #1
    Registered User
    Join Date
    04-05-2019
    Location
    Dayton, Ohio
    MS-Off Ver
    2018
    Posts
    3

    Excel Programming help need to find multiple averages and sums

    Hey,

    I am new to excel and need help creating a macro to do a simple task.

    First, I would like excel to take the sum of the cells in B2:B1441 and place that sum in cell J2
    I would like it to then take the sum of the cells in B1442:B2881 and place that sum in cell J3
    And continue this trend up until we take the sum of B420542:B421981 and place that in cell J294

    Following that, I would like to do the same thing for column C
    For example, take the sum of the cells in C2:C1441 and place that sum in cell K2
    Up until the point where the sum of cells C420542:C421981 and place that in cell K294

    I would like to repeat that for columns up until column G
    Where for example the sum of the cells G2:G1441 would be placed in Cell O2
    Up until the point where the sum of cells G420542:G421981 and place that in cell O294


    After that, I would like to do the same function, but taking the averages of the columns instead of the sums.

    For example, I would take the average of cells B2:B1441 and place that in cell R2
    And continue this trend up until we take the average of B420542:B421981 and place that in cell R294

    I would like to continue this trend for the same columns (B-G) placing them in the corresponding cells
    For example, I would continue until we take the average of G2:G1441 would be placed in Cell W2
    Up until we take the average of cells G420542:G421981 and place that in cell W294

    Thank you so much. Help is very much appreciated
    Picture Excel.PNG

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Excel Programming help need to find multiple averages and sums

    Not a macro but, in J2 dragged down and across to G2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Use a similar formula with AVERAGE instead of SUM
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. Programming Help Needed for Multiple Averages and Sums
    By quickc2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2019, 06:02 PM
  2. Need help with simple excel macro to take sums and averages
    By quickc2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2019, 11:27 AM
  3. Using time to calculate averages and sums
    By ckydmk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2017, 11:28 AM
  4. Replies: 4
    Last Post: 03-13-2015, 05:34 AM
  5. Filtering and averages, sums
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-07-2014, 07:05 AM
  6. Calculating Column data sums and then averages
    By piercebrosnan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2013, 11:52 PM
  7. Using Conditional Sums/Averages on Arrays
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2006, 10:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1