Results 1 to 3 of 3

Formula to get a count

Threaded View

  1. #1
    Registered User
    Join Date
    12-12-2014
    Location
    Arlington, Texas
    MS-Off Ver
    365
    Posts
    16

    Formula to get a count

    Attached is my document I am having issues with.

    I have two different formulas in cells G2 and H2 to get a sum total based on the last number in Column A.

    For example:

    U12 Boys = U12
    U15 Boys/U15 Girls = U15 (since U15 is the last number listed)
    U12 Boys/U15 Boys/U18 Boys = U18 (since it is the last number listed)
    and so on

    The total I have from the formulas both ways equal 183, but the actual total should be 191.

    Counts I am getting:
    Divisions Total Total
    U20 Division 39 39
    U18 Division 85 85
    U15 Division 45 45
    U12 Division 14 14
    Total 183 183

    Row Count
    U20 40
    U18 88
    U15 49
    U12 14
    191

    Can anyone please help me figure out why the counts are off?

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count Blank and count based on criteria only Formula Allowed
    By Harmender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2019, 12:26 PM
  2. Formula Required to Count Rows only if condition is meet or else dont count
    By Shahbazk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-22-2017, 08:39 AM
  3. (Count Formula) Count if two seperate ranges create unique combination
    By Geekcrux in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2016, 07:00 AM
  4. Formula to count number of visible rows, and formula to count visible blanks
    By radoncadonc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2015, 04:19 PM
  5. [SOLVED] Count formula not count hidden cells in table
    By tlacloche in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2013, 02:35 PM
  6. [SOLVED] Count and average formula needed to not count text field
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-07-2013, 05:30 PM
  7. Replies: 5
    Last Post: 08-29-2012, 05:25 PM

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