LinkBack URL
About LinkBacks
Hey guys
I have created a countif formula, however I need it to be case sensitive as its giving me incorrect results
my query is, is there a formula which i can use to apply it to my countif formula ?
Hey guys
I have created a countif formula, however I need it to be case sensitive as its giving me incorrect results
my query is, is there a formula which i can use to apply it to my countif formula ?
Try:
=SUMPRODUCT(--EXACT(A1:A10,"Criteria"))
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
You need to use EXACT and it won't work with COUNTIF... but try:
=SUMPRODUCT(--(EXACT(H14:H17,"a")))
where you would be comparing H14:H17 to lower case "a". Adjust as necessary.
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.
Well this is the problem i am facing
IF you go to the “camp user info” tab and look at column O and where it says for e.g. 2, and then look at column k, and select the copy the reference number.
then go to “lead user info” tab, and “ctrl F” and paste that reference number it should find two reference numbers. However looking at the two reference numbers it found within the lead user info tab, they are identically the same expect the case reference number
i am still learning with excel so sorry, if i am breaking this down for you guys . is it possible if you could try and apply your formula next to my column O on the camp user info tab
i am trying to attach my excel file, however it wont attach. Do you guys have any other recommendations to help me ?
Reduce the file size or zip it and attach it.
i have zipped it, it just wont allow me to attach it
hi, please find a screen print in word, hopefully this will explain it better !
Last edited by masond3; 12-01-2011 at 10:11 AM.
The zipped file has to be less than 9.77 MB.
Try cutting it down... removing unnecessary sheets, and extras...
Hi i have attached a screen print in word, i hope that helps
I see in the formula in the attachment that your countif criteria is 'Lead User Info'!I:L... that is 4 columns. Do you really mean just 'Lead User Info'!I:I (one column)?
Hi
The formula which I used should be basically saying look at “lead user info tab” and look at column I, then go back to tab “ camp user info tab” and look at column K. If it matches how many are there
So something like:
=SUMPRODUCT(--(EXACT('Lead User Info'!I:I ,K4)))
should work... but SUMPRODUCT doesn't like whole column references.. so it is better to limit it like:
=SUMPRODUCT(--(EXACT('Lead User Info'!I$2:I$1000 ,K4)))
adjust as necessary.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks