I'm attempting to use the countif formula to make sure a number is entered only once in 4 nonconnected ranges, I492:I496, I499:I503, K492:K496 and K499:K503. I've tried everything I know and as I'm self taught and my teacher is an idiot, I'm not having any luck. Any help will be very much appreciated as I'm down to the last 2 hairs on my head and one of them is already loose.
Why not just add the 4 Countif functions together:
=Countif(I492:I496,X1)+Countif(I499:I503,X1)+Countif(K492:K496,X1)+Countif(K499:K503,X1)
Where X1 houses value/string to count.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I tried your solution, but it didn't work. At least it didn't say that the formula was bad, it just didn't work. Thanks anyway
What didn't work about it? Did it give an error? or Wrong count?Originally Posted by village_idiot
Remember to change X1 to the actual cell housing the value to count or replace it with the value you wnat to count.
Last edited by NBVC; 05-14-2007 at 04:02 PM.
It didn't cause an error, but then again it didn't do anything at all. I know that in the bigger picture this problem isn't much, but like I said I only have 2 hairs left and one is loose. I'll included a zipped file so you can see what I'm doing. I want to keep the people from drawing a card that is already drawn. Again thanks for any and all help.
So have your ranges changed to I5:I9, K5:K9, I12:I16, K12:K16?
I don't see where you tried the formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
village_idiot 
Register To Reply
Bookmarks