Results 1 to 5 of 5

=counta help

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2018
    Location
    Newcastle, England
    MS-Off Ver
    2016
    Posts
    25

    =counta help

    Hi I'm currently making a world cup score predictor in excel and have the formulae below which works perfectly but struggling to keep track of result as it counts blank cells as a draw, wondering if any one would know how to incorporate the COUNTA feature or if there is another way around it so it ignores blank cells?

    =IF(OR((I8>J8)-(M8>N8),(I8<J8)-(M8<N8)),0,IF(AND(I8=M8,J8=N8),3,2))
    Last edited by Deaco; 06-18-2018 at 03:55 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with CountA
    By kufta4 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-18-2013, 11:13 AM
  2. COUNTA on VBA
    By bryan444 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2012, 03:32 PM
  3. Using CountA
    By DesmondLeo in forum Excel General
    Replies: 1
    Last Post: 07-10-2009, 01:11 AM
  4. COUNTA help please
    By macquarl in forum Excel General
    Replies: 3
    Last Post: 10-03-2006, 08:07 PM
  5. using Counta
    By martins in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-03-2006, 07:10 PM
  6. [SOLVED] COUNTA
    By Karen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2006, 05:50 PM
  7. counta and
    By luvthavodka in forum Excel General
    Replies: 2
    Last Post: 07-05-2005, 07:07 PM
  8. [SOLVED] counta
    By rabol in forum Excel General
    Replies: 3
    Last Post: 03-06-2005, 02:06 PM

Tags for this Thread

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