Results 1 to 5 of 5

Excel 2007 counting across rows to the next blank cell

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Darlington, England
    MS-Off Ver
    Excel 2007
    Posts
    18

    Excel 2007 counting across rows to the next blank cell

    Hi There,

    I'm looking at writing a formula to count the number of days worked since an employees last day off (results to appear in E7)

    From how my spreadsheet is designed, I'm needing to count the number of start/finish cells in Row 7 (F7:G7,J7:K7, and so on) until I get to a blank start/finish cell (and then I'm assuming I'll need to divide by 2 at the end of the formula to get my total number of days) I then need to start counting again once the spreadsheet is update till the next blank cell.

    Is this possible? I'm only recently delving into the more complicate formula so any advice/suggestions would be appreciated

    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing Blank Rows in Excel 2007
    By narendrabr in forum Excel General
    Replies: 9
    Last Post: 03-08-2013, 03:24 AM
  2. [SOLVED] Inserting a specific number of blank rows between cells - Excel 2007
    By excelactuary in forum Excel General
    Replies: 3
    Last Post: 03-06-2013, 11:54 AM
  3. Excel 2007 - Counting of blank cells with specific criteria
    By nishu.raghavendra in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2013, 09:46 AM
  4. Excel Counting a blank cell as a value
    By Barking_Mad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2009, 11:53 AM
  5. Use Sorting to Delete Blank Rows in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-19-2007, 12:26 PM

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