+ Reply to Thread
Results 1 to 2 of 2

Value reference from formula result for Sum Calculation

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    Edmonton, Alberta
    MS-Off Ver
    2016
    Posts
    61

    Value reference from formula result for Sum Calculation

    Hello,
    please see attached document for reference.

    I would like a formula in rows 3/6/9/12 that references the value shown from a formula in rows 4/7/10/13.

    for example:
    In cell C3 I would like it look at C4 and copy the value (only) shown, in order to be able to SUM each row in column P.
    If the cell is blank then I would like it to return a '0' or blank value.

    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Value reference from formula result for Sum Calculation

    It seems you could use >> =IF(N(C4),C4,0) >> in C3 copied to the right.
    HTH
    Regards, Jeff

+ 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] Formula Help - Calculation result keeps looping
    By Steve_E in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2018, 11:09 PM
  2. [SOLVED] Formula result = 0 when calculation steps return value
    By wacky_diva in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2017, 04:15 AM
  3. [SOLVED] Help! Calculation Time and changing formula result to a value?
    By onp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-17-2014, 03:04 PM
  4. Replies: 1
    Last Post: 01-05-2012, 09:14 PM
  5. Formula Does Not Copy, Previous Calculation Result Does
    By abcommendatore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2010, 12:59 PM
  6. Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 PM
  7. [SOLVED] formula result #value! needs to equal zero for average calculation
    By LauraRose in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2006, 02:20 PM

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