Results 1 to 11 of 11

EDITED: Easy way to add a large amount of individual values in tables?

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2017
    Location
    Stockholm, Sweden
    MS-Off Ver
    MS Office 2010
    Posts
    10

    EDITED: Easy way to add a large amount of individual values in tables?

    EDITED FOR SIMPLIFICATION :

    Hello,

    I'm not sure how to describe my problem in an easy manner but here goes:

    I have three tables, A1:C116, D1:F116 and G1:I116. I want to add the numbers in A1, B1 and C1 to the numbers in D1:116, E1:116 F1:119 respectively in G1:I116, the numbers in A/B/C2 to D/E/F1:116 in C117:232 etc. There is also three constants in J1:L1 that are to be added to G:I.

    This didn't seem too daunting at first, until I realised how long it'd take to do that amount of manual input. Is there an easier way to automate this somehow?

    Regards,
    Jens
    Last edited by jenspalmqvist; 01-08-2018 at 09:04 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. adding a large, LARGE amount of text to a spreadsheet
    By Wolfpackfan in forum Excel General
    Replies: 4
    Last Post: 05-30-2016, 01:30 PM
  2. [SOLVED] Is there an easy way to get the amount of how often a cell is used in a formula?
    By DeinAlbtraum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2015, 02:10 AM
  3. Replies: 10
    Last Post: 12-21-2014, 06:53 PM
  4. summing individual values to match total amount
    By cassiopea in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-28-2014, 07:14 AM
  5. Replies: 1
    Last Post: 04-22-2013, 12:13 AM
  6. [SOLVED] quantity x amount = probably an easy one but I can't figure it out.
    By cameltoe in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-21-2012, 06:14 PM
  7. Help replacing large amount of text with another large amount of text??
    By floydrob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2012, 05:01 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