Results 1 to 7 of 7

Count last 7 days of pupil attendance that exceeds 31

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2015
    Location
    london england
    MS-Off Ver
    micro off 2010
    Posts
    4

    Count last 7 days of pupil attendance that exceeds 31

    Hi all


    was after some help with an excel formula!!! does anyone know what formula I would use to adjust the starting point of its criteria for example if I had a spreadsheet of pupil attendance by day but then wanted a formula to show how many days I had 31 pupils in but only counting for the last 7 days(values)? so then each time I add a new value it would still only count back 7 days.
    if the starting point was the same I would use COUNTIF(Sheet1!B:C,31) but how do I add only count the last 7 values without having to adjust the formula each time I add a value. as below

    day 1 - 30
    day 2 - 34
    day 3 - 31
    day 4 - 32
    day 5 - 31
    day 6 - 31
    day 7 - 33

    so when I add day 8 it would only count days 2,3,4,5,6,7 and 8. then when I add day 9 it will count days 3,4,5,6,7,8 and 9.

    thank you in advance for any help
    Last edited by Richard Buttrey; 05-30-2015 at 09:23 AM. Reason: Inadequate title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Poll on - Lots of simple formulas vs fewer but more complex formulas
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-20-2014, 08:51 PM
  2. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  3. Insert cells, fill formulas down, set formulas for dynamic range
    By Snickers65 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2013, 01:43 PM
  4. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  5. Replies: 5
    Last Post: 05-05-2008, 02:22 PM

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