Countif problem - Probably a formatting problem
Attachment 694916
I'm stumped with this little problem. In Column B I have a load of durations formatted as Custom mm:ss and in cells D2:J2 I have some other durations also formatted as Custom mm:ss. All I want to do is count how many cells in the B column are less than the duration in cell D2. I'm assuming that a Countif formula is the best way to do but I can't get it to work. Cell D3 should really be showing 7, not 371. Any ideas what I'm doing wrong?
Last edited by simonwilliamstutor; 09-13-2020 at 02:51 AM. Reason: Attaching spreadsheet
Change the logic ">="
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
That makes the result 0.Originally Posted by shukla.ankur281190
It seems that your B column is in Text format... Change it into time format
For better solution please share the sample file
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Thanks. I've attached the spreadsheet to the OP. I've changed all the durations to Time format and stripped out any extraneous data. Cell C2 should give a result of 7, but as you'll see in the attached file it's still showing 0.
Hi, amend the formula from COUNTIF(A1:A371,"<=C2") toFormula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks