LinkBack URL
About LinkBacks
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
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.
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.
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?
Maybe...
=SUMPRODUCT(COUNTIF(INDIRECT({"I492:I496","I499:I503","K492:K496","K499:K503"}),X1))
Hope it helps!
To NBVC: the addresses has changed, because the work sheet I was working from has a lot of other info that I garnered from this fantastic web site and it's even more fantastic people who take the time to help me and my fellow noobs.I cut and pasted only the one item to work on. I tried your formula and since it didn't do anything I removed it.
To VANE0326: thanks for the info, but according to Excel and I quote: "You may not use unions, intersections, or arrey constants for Data Validation or Conditional Formats" unquote. So, I'm back at the same point, not that it matters much, my last 2 hairs fell out last night, so I guess I'll have to try it from another direction.
Thanks for all the info and I'll keep looking.
To NBVC: the addresses has changed, because the work sheet I was working from has a lot of other info that I garnered from this fantastic web site and it's even more fantastic people who take the time to help me and my fellow noobs.
If you specify exactly what you are doing and what results you expect and where you expect them, referencing the cells in the sheet you attached, I am sure we can come up with a solution....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks