Isabellalearning
New member
- Joined
- Oct 23, 2014
- Messages
- 7
- Reaction score
- 0
- Points
- 0
Hello I am wanting to count the number of times a word appears in a row ONLY if B column contains a particular word eg:
Names in a column A
suburb in column b
Column C - JU has Id codes under dates (daily eg: 1/11/14, 2/11/14 etc)
In a new tab I want to see results :
if column b contains the text "testing" then look across that entire row from column for only september dates ) and if the code AL appears calculate this as 1.
Does that make sence? I have attached a sample as I dont think im explaining myself properly, sorry..
isabella
Names in a column A
suburb in column b
Column C - JU has Id codes under dates (daily eg: 1/11/14, 2/11/14 etc)
In a new tab I want to see results :
if column b contains the text "testing" then look across that entire row from column for only september dates ) and if the code AL appears calculate this as 1.
Does that make sence? I have attached a sample as I dont think im explaining myself properly, sorry..
isabella