excel - Using a countif to count cells that can equal two different criteria -


i looking use countif or countifs add set of 7 cells each cell trigger 2 different criteria.

the cells contain numbers , need counter if see if cell greater 0 or lower other static cell.

most tutorials , examples can find either describe , statements or end getting cell counted twice triggers both criteria if number between 2 comparison factors.

here pseudo code of looking for.

countif(balance, greater 0 or greater last months payment) count cell once

please ask questions , pre-thanks responses , time taken read question.

-------------------edit-------------------------

don't worry answered own question.

all hail rubber duck method.

--------------second edit 07/04/15----------------

thank-you responses. had solved issue 30 secs after posting question , did post edit "revised" user called mike? , removed.

i realized ask if balance less since impossible balance go less 0 matter of checking lower last months payment.

i busy trying build in checks balance wasn't below 0 remember other factors in system prevented it.

all needed write problem down answer trigger in head.


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -