LinkBack URL
About LinkBacks
mtma 
How do I count the number of times a cell is great than E5 or less than C5 in an entire table column?
How do I count the number of times a cell is great than E5 or less than C5 in an entire table column?
Something like
=COUNTIF(Table1[Amt],">="&E5)-COUNTIF(Table1[Amt],">"&C5)
----------------
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Negative reps for an empty post? I didn't see that one coming...
If the OP had been watching, he would have seen you had posted then must have removed it. Negative, that's a bit harsh, but how do you know that happened. This rating system is just so much tosh to me, but if the forum does have it it should have a review system for such inappropriate actions.
Yes I did post a formula which I deleted right away since it was way different than your solution and I assumed I got the task all wrong, it has happend before. I know I got a negative rep cause it shows up as red instead of green and I'm down one point.
The negative rep upset me as much as... dropping my peanut butter sandwich on the floor (peanut side down), so I'll survive.
The negative reps option is right there and there is nothing that says you can't use it so I guess it's up to anyone to use it. However, there is also nothing that says I can't ask why.
mtma, I assume Bob solved your problem so why the neg. reps? Were you annoyed that I withdrew my post or were you just trying out the buttons?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks