Use COUNTIF across a range of cells with formulas

Excel Discussion in 'Microsoft Office' started by Measterbro, Sep 13, 2017.

  1. Measterbro

    Measterbro

    Joined:
    Sep 13, 2017
    Likes Received:
    0
    I am trying to count the number of cells in a row that contain the letter "O". Every cell contains a formula. If I use this it works correctly and returns a one since D3261 has that letter:

    Code:
    =COUNTIF(D3261,"O")
    However if I use this, I get a zero even though D3261 still has that letter:

    Code:
    =COUNTIF(C3261:D3261,"O")
    If I remove the formulas from C3261 and D3261, and manually type the letter "O" in D3261, both formulas work correctly.
     
    Measterbro, Sep 13, 2017
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Sumo
    Replies:
    1
    Views:
    654
    PapaBear56
    Jul 20, 2005
  2. godonnygo

    Excel Excel: COUNTIF/Data questions

    godonnygo, Aug 9, 2006, in forum: Microsoft Office
    Replies:
    10
    Views:
    987
    klaus
    Aug 13, 2006
  3. Kiwi Berg

    Excel Excel - Countif Not Working! It misses some cells.

    Kiwi Berg, Dec 22, 2008, in forum: Microsoft Office
    Replies:
    1
    Views:
    871
    Kiwi Berg
    Dec 23, 2008
  4. vaggy2009

    Excel Countif formula for Excel 2003

    vaggy2009, Apr 26, 2009, in forum: Microsoft Office
    Replies:
    2
    Views:
    1,563
    vaggy2009
    Apr 30, 2009
  5. Netskie
    Replies:
    0
    Views:
    1,086
    Netskie
    Dec 6, 2010
  6. Bitsbb01

    Excel Problem with macro in Excel VBA working across sheets

    Bitsbb01, Apr 9, 2012, in forum: Microsoft Office
    Replies:
    1
    Views:
    791
    nehanaik25
    Apr 20, 2012
  7. Sanders92

    Excel Excel 2003 - Formula Writing (Countif, Sumif, Countblank)

    Sanders92, Aug 31, 2012, in forum: Microsoft Office
    Replies:
    2
    Views:
    913
    Sanders92
    Aug 31, 2012
  8. John Romano

    Excel Macro to use cells as a autofilter

    John Romano, Sep 3, 2017, in forum: Microsoft Office
    Replies:
    0
    Views:
    141
    John Romano
    Sep 3, 2017
Loading...