Results 1 to 21 of 21

Using Countifs to ONLY COUNT numbers NOT FORMULAS

Threaded View

nightdawg Using Countifs to ONLY COUNT... 05-17-2016, 10:46 AM
Pete_UK Re: Using Countifs to ONLY... 05-17-2016, 10:51 AM
nightdawg Re: Using Countifs to ONLY... 05-17-2016, 10:57 AM
Tony Valko Re: Using Countifs to ONLY... 05-17-2016, 10:59 AM
Tony Valko Re: Using Countifs to ONLY... 05-17-2016, 10:52 AM
nightdawg Re: Using Countifs to ONLY... 05-17-2016, 11:03 AM
Pete_UK Re: Using Countifs to ONLY... 05-17-2016, 11:07 AM
Tony Valko Re: Using Countifs to ONLY... 05-17-2016, 11:09 AM
nightdawg Re: Using Countifs to ONLY... 05-17-2016, 11:14 AM
Pete_UK Re: Using Countifs to ONLY... 05-17-2016, 11:16 AM
nightdawg Re: Using Countifs to ONLY... 05-17-2016, 11:20 AM
nightdawg Re: Using Countifs to ONLY... 05-17-2016, 11:16 AM
nightdawg Re: Using Countifs to ONLY... 05-17-2016, 11:09 AM
FDibbins Re: Using Countifs to ONLY... 05-17-2016, 11:23 AM
nightdawg Re: Using Countifs to ONLY... 05-17-2016, 11:36 AM
Tony Valko Re: Using Countifs to ONLY... 05-17-2016, 12:03 PM
Pete_UK Re: Using Countifs to ONLY... 05-17-2016, 04:41 PM
  1. #1
    Registered User
    Join Date
    05-06-2011
    Location
    Dawsonville, Ga
    MS-Off Ver
    Excel 2013
    Posts
    11

    Using Countifs to ONLY COUNT numbers NOT FORMULAS

    I have been trying for an hour to figure out how to get a formula that counts only if the cell contains a number. I don't want it to count a cell if it contains text or a formula. If it counts a cell that contains text, it counts a descriptive header that I don't need want counted. If it counts a cell that contains a formula, it double counts something. Is it possible to do this? If needed I can post the many, many failed formulae that I have tried to make this work.


    As you can see, I only want to count the people that have a positive number in column C. If I count C7 I count Joey Joe Joe twice. If I count C1, I count something that I don't want counted!

    Thanks in advance.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count numbers vs. formulas in a range
    By aquixano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2016, 11:26 PM
  2. [SOLVED] Need Help with a COUNTIFS formulas
    By davidrias in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2015, 09:29 AM
  3. [SOLVED] Combining CountIfS Formulas
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2013, 09:25 AM
  4. Formula Optimization on several Countifs formulas
    By dcgrove in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-18-2013, 02:31 PM
  5. Replies: 6
    Last Post: 12-22-2012, 05:04 PM
  6. COUNTIFS OR...multiple countifs without duplication in the numbers
    By HooligaD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 09:53 AM
  7. Replies: 0
    Last Post: 12-16-2011, 09:01 AM

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