Results 1 to 5 of 5

Formula for counting date & cell data

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2010
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    46

    Formula for counting date & cell data

    Hi all,

    I recently had some help with a formula for a worksheet and this is a follow up to this worksheet where I need help creating another formula.

    I have attached an example document.

    Basically, what I am trying to do is record how many times a group of files were opened on a set date so I can create a relevant chart.

    In the example I have uploaded, I already have forumlas in place for calculating how many times each file has been opened and how many files have been opened per group. i'd like to break this down into daily counts if possible.

    The formula I am looking for is for cell Q3 to calculate the number of times a file from Section 1 (G5:G43) was opened on 06/06/2011.

    I hope this makes sense and if not please feel free to get in touch and I will try to explain it better. I'm fairly novice when it comes to excel so please excuse my ignorrance if I am confused by any replies!


    Regards,

    Bryan
    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