Results 1 to 16 of 16

Re-Calc from new cell if so many cells are blank

Threaded View

zny_kan Re-Calc from new cell if so... 11-11-2008, 03:17 PM
NBVC What happens if there are... 11-11-2008, 03:25 PM
zny_kan If there are more than 5 days... 11-11-2008, 03:44 PM
NBVC What about if there are less... 11-11-2008, 03:46 PM
zny_kan I'll try it out. thanks 11-11-2008, 03:53 PM
zny_kan Doesn't work out for me. ... 11-11-2008, 04:25 PM
NBVC If you post a sample sheet... 11-11-2008, 05:28 PM
zny_kan Here is it. I hide some... 11-11-2008, 05:44 PM
NBVC Can you try again and upload... 11-11-2008, 05:47 PM
zny_kan on sheet 2010 is the jpg I... 11-11-2008, 05:58 PM
NBVC In H33: If you are... 11-11-2008, 06:33 PM
zny_kan Wow, seems to work perfect. ... 11-11-2008, 06:46 PM
NBVC It doesn't make a difference.... 11-11-2008, 10:16 PM
zny_kan And thanks for helping me. I... 11-11-2008, 07:03 PM
zny_kan cool. While I was looking... 11-11-2008, 10:41 PM
NBVC That Match() formulation will... 11-11-2008, 10:58 PM
  1. #1
    Registered User
    Join Date
    11-11-2008
    Location
    Canada
    Posts
    15

    Re-Calc from new cell if so many cells are blank

    I have 2 columns.

    Column E has the amount of time each day.
    Column G is where I want the Sum to be displayed.

    I need Column G to do a =Sum(E4:E33), but if anywhere in between E4 and E33 there is a period of 5 days where it totals 0 then I want column G to re-add from the first day where there is a amount in it.

    Ex: E4 to E10 totals 7 (1 per day), from E11 to E15 totals 0, from E16 to E33 totals 18 (1 per day again).

    In Column G at G10 it should total 7, at G11 it should be 6, G12 5 etc until it hits G15 where it sees the 5 previous days nothing was entered so it enters a value of 0, because G15 is set to 0, G16 will start adding from E16 till E33, until somewhere down the line it sees another period of 5 days where it adds up to 0 again.
    Last edited by zny_kan; 11-11-2008 at 07:03 PM.

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