I am looking to use COUNTIF or COUNTIFS to add up a set of 7 cells where each cell could trigger 2 different criteria.
The Cells contain numbers and I need the counter if to see if the cell is greater than 0 OR lower than an other static cell.
Most tutorials and examples I can find either describe AND statements or end up getting the cell counted twice as it triggers both criteria if the number is between the 2 comparison factors.
Here is some pseudo code of what I am looking for.
COUNTIF(Balance, is greater than 0 OR greater than last months payment) then count cell ONCE
Please ask any questions and pre-thanks for any responses and time taken to read my question.
-------------------EDIT-------------------------
Don't worry answered by own question.
All hail the rubber duck method.
--------------Second Edit 07/04/15----------------
Thank-you for the responses. I had solved the issue about 30 secs after posting the question and did post an edit but this was "Revised" by a user called Mike? and removed.