meiirmeiir21
New Member
- Joined
- Jan 18, 2010
- Messages
- 22
Hello Every body,
I need your help to advice how can i use countif to count multiple criteria s where these criteria s are variable per each row..:
my sheet2 is:
Column A Column B
N1_N2 N2_N1
N1_N3 N3_N1
N1_N4 N4_N1
. .
. .
. .
I need to count at column C the occurring of column A and B Text in a certain range..
for row#1 @ C1 I used
=SUM(COUNTIF(Sheet1!B3:IV151,"*"&{"N1_N2","N2_N1"}&"*")) >>It works fine
but i still need to call N1_N2 & N2_N1 from A1 & B1 ... then i can drag..
Any suggestions?
I need your help to advice how can i use countif to count multiple criteria s where these criteria s are variable per each row..:
my sheet2 is:
Column A Column B
N1_N2 N2_N1
N1_N3 N3_N1
N1_N4 N4_N1
. .
. .
. .
I need to count at column C the occurring of column A and B Text in a certain range..
for row#1 @ C1 I used
=SUM(COUNTIF(Sheet1!B3:IV151,"*"&{"N1_N2","N2_N1"}&"*")) >>It works fine
but i still need to call N1_N2 & N2_N1 from A1 & B1 ... then i can drag..
Any suggestions?
