+ Reply to Thread
Results 1 to 4 of 4

Use single custom formula to product results in multiple cells

  1. #1
    Registered User
    Join Date
    02-19-2016
    Location
    somewhere
    MS-Off Ver
    2013
    Posts
    1

    Use single custom formula to product results in multiple cells

    Example.jpg

    Dear members this is my first post and I wish to seek help

    I am working on a sheet with data over 3000+ rows
    if you look at (attached) example, I want to use results of a custom formula (shown in cell "I4") in all cells F4 through F13,
    I dont want to copy, paste this formula in each cell, as my formula in original sheet is very complex to be used in each cell.

    I look forward for a quick reply


    P.S. I am sorry if some post with similar question is already posted, I ran through many pages but was not able to find one.

    Thank you

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Use single custom formula to product results in multiple cells

    Hi
    Try to double click on the bottom right of the cell with the formula in F4.
    You don't need parenthesis

  3. #3
    Registered User
    Join Date
    09-20-2016
    Location
    bhopal
    MS-Off Ver
    2003
    Posts
    17

    Re: Use single custom formula to product results in multiple cells

    Pls provide complex formula...

    So it is better to support.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Use single custom formula to product results in multiple cells

    Hi, welcome to the forum

    Im confused as to what you actually want?
    I dont want to copy, paste this formula in each cell, as my formula in original sheet is very complex to be used in each cell.
    Maybe...
    =SUMPRODUCT(D4:D13/E4:E13/100

    what would your expected answer look like?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Product of Column Counts in a Single Formula
    By k64 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 10:35 AM
  2. Multiple Search Criteria produces (list) Multiple results in a single cell
    By snake007uk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2014, 12:13 PM
  3. Replies: 3
    Last Post: 02-21-2014, 05:33 PM
  4. [SOLVED] Use a single formula to calculate the product of the top 10 cells with another column
    By BNCOXUK in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-30-2013, 04:18 PM
  5. [SOLVED] Single product with multiple variations in multiple rows need to consolidate to single row
    By 65monroe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2013, 01:42 AM
  6. Lookup Formula for multiple cells with multiple results
    By CKD777 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-14-2011, 11:32 PM
  7. Can I send results of a formula to multiple cells?
    By Scarlett O in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2005, 02:07 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