Avatar of Michael Paxton
Michael Paxton
Flag for United States of America

asked on 

Count with OR in Excel

This is probably ridiculously easy, and I'm complicating it unnecessarily.  I have a data range of p2:p32 that contains values from -200% to + 1600%.  I am trying to count those cells that are greater than 25% or less than -25%.  When I use countif and put the first criteria in, it calculates successfully.  When I add the second, it returns 0.  Is countif an AND function?

What would be the correct formula for this?


SpreadsheetsMicrosoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Shums Faruk

8/22/2022 - Mon