Hello everyone,
I've been at this for a while now and I am simply at am impasse.
I'm using a COUNTIF formula, and would like it to count all the instances of "< $50K". Literally just that string. I don't want to actually look for values less than $50K, but the string "< $50K". Is this possible? If so, how? I thought I might need to use a code of some sort for "<" to be read how I want, but I haven't had any luck.
Thanks!
Try this:
Formula:
Please Login or Register to view this content.
Thanks, but it didn't work.
Yes it does. See attached spreadsheet. Perhaps you have extra spaces somewhere in your cells?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Whoops! I DOES work. Thank you! It was an error on my part. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks