Share via

Nested COUNTIF Function

Anonymous
2010-09-22T02:22:20+00:00

I am trying to create a Nested COUNTIF function that will count the number of cells that are greater than .3, OR less than minus .3.  I tried:  =OR(COUNTIF(A1:F1,">.3"),COUNTIF(A1:F1,"<-.3")).  That gives me the result TRUE.

Any help appreciated,

Thanks,

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2010-09-22T02:43:02+00:00

    You don't nest them... you would simply add the two together

    =COUNTIF(A1:F1,"<-.3")+COUNTIF(A1:F1,">.3")

    NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.

    0 comments
Answer accepted by question author
  1. Anonymous
    2010-09-22T02:39:15+00:00

    Hi - no need to nest - just add:

    =countif(A1:F1,">0.3")+countif(A1:F1,"<-0.3")

    Rgds

    Geoff

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-09-22T02:47:57+00:00

    Too easy!!! Thanks so much.

    0 comments