Results 1 to 5 of 5

Countifs criteria between two dates

Threaded View

Si902 Countifs criteria between two... 12-23-2011, 01:26 PM
daddylonglegs Re: Countifs criteria between... 12-23-2011, 02:20 PM
Marcol Re: Countifs criteria between... 12-23-2011, 02:29 PM
Si902 Re: Countifs criteria between... 12-24-2011, 05:00 AM
Marcol Re: Countifs criteria between... 12-24-2011, 05:47 AM
  1. #1
    Registered User
    Join Date
    08-02-2009
    Location
    Lancashire, England
    MS-Off Ver
    Excel 2007
    Posts
    84

    Countifs criteria between two dates

    Hi All

    Im trying to use a COUNTIFS function to return the number of times a football team plays between two given dates.

    I've tried various combinations but cannot get it to work!!

    I'll attach a copy of the workbook, but basically i have Date in Column A, Home team Column B, Away team column C.

    I have a cell with the start date (I2) and cell with end date (I3) to set the required period.

    I have list of the teams in the league H5:H24, results for each team to be displayed in next column next to relevant team.

    My last effort =COUNTIFS(B:C,H5,A:A,">= I2",A:A,"<= I3") results in #VALUE!

    Not sure weather countifs is appropriate, maybe something better?

    Any pointers in the right direction would be greatly appreciated.

    Thanks in advance
    Attached Files Attached Files
    Last edited by Si902; 12-24-2011 at 05:00 AM.

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