+ Reply to Thread
Results 1 to 3 of 3

creating a formula that skips empty cells

  1. 10-19-2007, 03:23 PM #1
    turbo90talon
    turbo90talon is offline
    Registered User
    Join Date
    10-19-2007
    Posts
    3

    creating a formula that skips empty cells

    im doing a meter reading on a daily basis but on weekends and sometimes during the week i dont do the reading. my problem is with the day following the missed read my calc is wrong. column c is the meter reading and column d is the usage. i get column d by subtracting the previous meter read from the current one (=IF(C9>0,C9-C8,0). my problem is after a non read day the usage ends up being the meter read. i need a formula that will search up column c until it finds a numerical figure to subract against the new read.
    thanks
    turbo90talon
    Last edited by turbo90talon; 10-19-2007 at 03:30 PM.
    Reply With QuoteRegister To Reply
  2. 10-19-2007, 04:49 PM #2
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,677
    assuming your first cell showing usage is D2 then try this formula in D2 copied down

    =IF(C2>0,C2-SUM(D$1:D1),0)
    Reply With QuoteRegister To Reply
  3. 10-19-2007, 08:31 PM #3
    turbo90talon
    turbo90talon is offline
    Registered User
    Join Date
    10-19-2007
    Posts
    3
    your formula works great "daddy".
    thanks for all your help
    Last edited by turbo90talon; 10-19-2007 at 09:43 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1