jon gordyn
New Member
- Joined
- Jan 24, 2005
- Messages
- 5
Count Occurrences of text with 2 conditions and wild cards
the only stupid question is the one not asked. here is what i can not figure out how to do:
Sheet A:
- a list of names in column A, appearing only once
- columns B through whatever contain a specific category (some 33 different ones)
Sheet B
- contains multiple entries for each person
- contains the same categories as sheet A, but only in 4 cells. basically each cell can have a multiple category entries.
I need to write a formula that takes the persons name from sheet A and scans through a range on sheet B. when it finds that persons entry, It counts the total number of occurrences for a given string in the same row taking into account wild cards. then place that number on Sheet A. the work book pretty much deals exclusively with words.
I have been using SUM(IF statements but i can not get it to read wild cards
any help would be appreciated
Jon
the only stupid question is the one not asked. here is what i can not figure out how to do:
Sheet A:
- a list of names in column A, appearing only once
- columns B through whatever contain a specific category (some 33 different ones)
Sheet B
- contains multiple entries for each person
- contains the same categories as sheet A, but only in 4 cells. basically each cell can have a multiple category entries.
I need to write a formula that takes the persons name from sheet A and scans through a range on sheet B. when it finds that persons entry, It counts the total number of occurrences for a given string in the same row taking into account wild cards. then place that number on Sheet A. the work book pretty much deals exclusively with words.
I have been using SUM(IF statements but i can not get it to read wild cards
any help would be appreciated
Jon