+ Reply to Thread
Results 1 to 2 of 2

Can't workout formula in table

  1. #1
    Registered User
    Join Date
    04-21-2007
    Posts
    7

    Can't workout formula in table

    I've been trying to create a formula for the following table all day, but with no luck, please see attached..

    In this table I do not want to count any minus numbers or a figure above 553should the figure 553 appear in the table, then any figures in rows above 553 are also void and are not to be added to the total.

    Is this possible?

    P.S the total of table B is correct and what I am after. The colours are for your benefit and not important

    cheers
    Attached Files Attached Files
    Last edited by JUBA; 04-22-2007 at 12:13 PM. Reason: did not attach an attachment

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by JUBA
    I've been trying to create a formula for the following table all day, but with no luck, please see attached..

    In this table I do not want to count any minus numbers or a figure above 553should the figure 553 appear in the table, then any figures in rows above 553 are also void and are not to be added to the total.

    Is this possible?

    P.S the total of table B is correct and what I am after. The colours are for your benefit and not important

    cheers
    Hi,

    in G3 put

    =IF(F3=553,0,IF(C3>0,C3+G2,G2))

    and fill that down as required.

    hth
    ---
    Si fractum non sit, noli id reficere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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