Forum Discussion

scottkramer.14's avatar
scottkramer.14
Copper Contributor
Apr 05, 2018

Needing a little help in understanding the logic I am trying to use IF and COUNT IF

Hi all.   I have two separate worksheets, one of which needs to be connected to another.  On  Sheet 1 for column K, I have either "true" or "false".  In Sheet 2 for cell B6, I want to count all the n...
Formulas & Functions
tips and tricks
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 05, 2018

Hi Scott,

 

Please try this formula: 

=COUNTIF(Sheet1!K:K,TRUE)

 

 

scottkramer.14's avatar
scottkramer.14
Copper Contributor
Apr 05, 2018
Thanks for you suggestion. I tried it and the answer came up 0, which I thought was odd.
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 05, 2018

    Hi Scott,

     

    I guess that the TRUEs and FALSEs are parsed as texts, and it seems that the COUNTIF function cannot handle this situation!

     

    So please replace the previous formula with this:

    =SUMPRODUCT(--(K:K="TRUE"))

    Hope that helps

Resources