Results 1 to 9 of 9

Retaining value from a formula if new result becomes in error

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Retaining value from a formula if new result becomes in error

    [See attached file as an example]

    I want to be able to manage an auto count of items in a spreadsheet based on the current date. This I can do:

    [A1]
    =today()

    [A3]
    22/09/2010

    [B3]
    =if(A1=A3,countif(range,criteria)


    Problem
    I would also like to have a history of counts. My issue is having making this an automated exercise.

    [A4]
    22/09/2010
    [A5]
    23/09/2010
    [A6]
    24/09/2010


    [B3]
    =if(A1=A4,countif(range,criteria)
    [B4]
    =if(A1=A5,countif(range,criteria)
    [B5]
    =if(A1=A6,countif(range,criteria)

    Issue
    When a new date occurs, I loose the previous value. Is there some automated way to retain this value before it goes into error?
    Last edited by paulus_c; 09-22-2010 at 06:26 PM. Reason: Updated attachment to remove ambiguity with the use of =today() function

Thread Information

Users Browsing this Thread

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

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