Forum Discussion

Chris Mercado's avatar
Chris Mercado
Copper Contributor
Nov 16, 2017

COUNTIF "or" RANGE

So, I have created a formula with multiple "COUNTIF" functions over varied ranges.  However, for a few cells within the formula, I only want the formula to count one cell or the other, but never both...
Formulas & Functions
tips and tricks
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 16, 2017

Hi Chris,

 

If we speak about single cells, not ranges, that could be

=--OR(E17>0,E24>0)

 

  • Chris Mercado's avatar
    Chris Mercado
    Copper Contributor
    Nov 16, 2017

    Thanks, that looks like it works, even incorporated with the rest of my COUNTIF formula for other cells...

Resources