Results 1 to 2 of 2

Sum between two dates

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2008
    Location
    Sydney
    MS-Off Ver
    MS Office 2010
    Posts
    10

    Sum between two dates

    Hi

    In the attached s/s I would like in the column D of the 'Results' worksheet to sum up the data from the D column of the 'Data' worksheet. Cells highlighted in red.

    However the condition is the Date of the Dvd should be between the two dates of the 'Results' worksheet. So my total in cell F4 of 'Results' worksheet should be the totql of the data before the 11/06/2009. In F5 it should be the total between the 11/06/2009 and the 21/06/2009.

    In 'Results' the expected total is in column F.

    I would like the formula to take the whole range of the column C in 'Data' worksheet and to be drilled down.

    Thanks for your help

    Damien
    Attached Files Attached Files

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