Forum Discussion
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...
Hi Chris,
If we speak about single cells, not ranges, that could be
=--OR(E17>0,E24>0)
Thanks, that looks like it works, even incorporated with the rest of my COUNTIF formula for other cells...