Results 1 to 11 of 11

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

Threaded View

  1. 01-08-2018, 10:37 PM #2
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2505
    Posts
    1,525

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

    Try this in G1, copy to I1 and down:

    =SUM(OFFSET(A$1,QUOTIENT(ROWS($A$1:$A1)-1,116),0),D1,J$1)
    Last edited by Estevaoba; 01-08-2018 at 11:00 PM.
    Reply With QuoteRegister To Reply
« 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. 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. Splitting up Dr. Names and Addresses into individual columns. NOT AS EASY AS IT SOUNDS!
    By sinaranje in forum Excel General
    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. Large amount of data, sorted and subtotaled. Trying to filter but SubT Values turn to 0
    By tallflower24 in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1