Hello,
I am having trouble figuring out the exact formula to count how many times a letter(s) appears in certain columns using a drop down box and counting them depending on what is selected in the boxes then placing them in a certain area. I have attached a sample sheet and provided a detailed description of exactly what i am trying to accomplish. If someone could please help me out i would greatly appreciate it. Thanks in advance.
Last edited by jleal; 08-27-2014 at 10:14 PM.
Try this in E52 copied down
=IF(ISTEXT(B52),SUMPRODUCT(--(ISNUMBER(SEARCH(TRIM(LEFT(B52,3)),$C$17:$C$47)))*(ISNUMBER(SEARCH(TRIM(RIGHT(B52,2)),$N$17:$O$47)))),"")
Seems to work for your example. It does depend on the length of the values you are looking up, are they all 1,2, or 3?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Posted twice for some strange reason.
Yes this worked i can use this.
Thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks