I am seeking help on below mentioned formula.
Details:
Please Login or Register to view this content.
1. I am counting a unique i.e. Dental in my master sheet in column C.
2. Then it count the values greater or equal to 0:29 and less then or equal to 0:20
But the issue is is it not counting the values which is equal to 0:29. what is the problem can any one help me please.
Last edited by hecgroups; 11-17-2012 at 11:01 AM.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
HTH
Regards, Jeff
I think you mean "... greater or equal to 0:20 and less then or equal to 0:29 ..."
It might be that you have formatted the cells to show 2 decimal places, and so it would appear that some of the 0.29 values are not being counted. However, the real values might be 0.291 or higher, and so they are outside your range. Applying ROUND(...,2) to column K might help.
Hope this helps.
Pete
Sorry i have corrected title. Thanks to you for correcting me.
Please See the attachment sample file.
Cell C5 is having the issue. the value should be 39. How i will tell you.
If you goto to Master sheet and applied filter and select Dental in column C. Keeping the filter goto column K and apply filter and select 0:20 till 0:29 then you will get the values at the status bar i.e. Bottom Left Corner.
I hope i have explained to you what is my problem.
The status bar shows 37 for me with that filter, which is the same number that your formula results in. Also, filtering just on Dental in column C gives a total of 204 in the status bar, which is also the total in your summary sheet, so I don't see that you are missing any values.
Hope this helps.
Pete
the formula is not calculating last 2 values i.e 0:29 in row no. 538 & 539
Well, it works for me in this sample file - I see that your original formula referred to cells AR5 and AR6, whereas it is I5 and I6 in this file, so presumably your real file is somewhat different to this one. Perhaps that might explain the difference.
Pete
But i have provided you the attached file which is include formula below.
I just want to know what is the mistake i am doing in the formula and why i am missing 0:29 values which is appearing 2 times in the list.Please Login or Register to view this content.
Look, I applied the filter that you suggested in post #5 and the status bar said there were 37 records. I can see rows 538 and 539 in the displayed list. I put this formula in K555:
=SUBTOTAL(2,K2:K553)
which confirmed there were 37 records. Your SUMPRODUCT formula in the summary sheet also produces a result of 37.
So why do you think that there are 39 ??
Pete
Please check the image below which is showing 39 records.
Total 39.jpg
Well, I don't see that.
I don't think I can help you any further, so I shall unsubscribe from this thread.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks