LinkBack URL
About LinkBacks
How do I edit the function to below to not count if in cell M16 the value is "solved"
Thank you for your help.
=COUNTIFS(A16:A9000,C2,N16:N9000,"<=0")
How do I edit the function to below to not count if in cell M16 the value is "solved"
Thank you for your help.
=COUNTIFS(A16:A9000,C2,N16:N9000,"<=0")
I think that this is what you are looking for.
Formula:
=IF(M16="solved","",COUNTIFS(A16:A9000,C2,N16:N9000,"<=0"))
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
No that's not it. The function you gave me does not give any value if "solved" entered M16:M9000.
It is my fault, I should have phrased my question better. I want the function to count, I just want it to ignore any count with "solved" in M16:M9000.
This is getting to be embarrassing. I check to see if there is a reply then reply only to find that there was a reply....Sorry Martin.
just extend the logic
=COUNTIFS(A16:A9000,C2,N16:N9000,"<=0",M16:M9000,"<>solved")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
This will not count the values if the matching value in column M is SOLVED.
Formula:=COUNTIFS(A16:A9000,C2,N16:N9000,"<=0",M16:M9000,"<>Solved")
happens to us alli usually make sure the formula is correct without typos before posting often leading to posting exactly the same as the poster before me
Unfortunately, I seem to be plagued by it. Sometimes there are answers that have been there for quite a while but I don't see them. Refreshing the page doesn't seem to help.
Thank you both so much. Apparently I cannot add reputation twice in the same post. But I sincerely thank you Martin for helping me.
As well as you newdoverman.
Thank you for the feedback.
Any time you see an answer from martindwilson, you can bet on it being very good. I always look for his answers in threads that I participate in and I learn a lot from them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks