Results 1 to 6 of 6

Count "Draw" scenario?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Question Count "Draw" scenario?

    Hi,

    Attached is a sample of my working excel.
    I'm trying to count the number of Draws that that "England" played.

    I used =IF(AND(Fixtures!A1:A5<>0,Fixtures!D1:D5<>0),COUNT(Fixtures!B1:B5="Apple")+COUNT(Fixtures!C1:C5="Apple")) but keep getting the error "FALSE".

    How do I make it count properly?
    Last edited by Lewis Koh; 05-17-2010 at 06:32 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