R
relaxandflow
I can't find the answer to this problem in any resource I have
looked...
I have two columns, E and K. Column E contains various place names, but
only if they are within a certain city; when the place is outside that
city, the cell in column E is blank. Column K contains the quarter that
a particular event occured. I want to count all the events that occured
within only that city during second quarter 2006. So, in the following
example, it would give me a count of 2 by counting only rows 3 and 5.
1 E K
2 Shinjuku 05-Q1
3 Chuo 06-Q2
4 06-Q2
5 Minato 06-Q2
Here is my attempt, but Excel doesn't like it...
=COUNTIF(AND(E2:E634="?*"),(K2:K634="06-Q2"))
Your help is much appreciated!
looked...
I have two columns, E and K. Column E contains various place names, but
only if they are within a certain city; when the place is outside that
city, the cell in column E is blank. Column K contains the quarter that
a particular event occured. I want to count all the events that occured
within only that city during second quarter 2006. So, in the following
example, it would give me a count of 2 by counting only rows 3 and 5.
1 E K
2 Shinjuku 05-Q1
3 Chuo 06-Q2
4 06-Q2
5 Minato 06-Q2
Here is my attempt, but Excel doesn't like it...
=COUNTIF(AND(E2:E634="?*"),(K2:K634="06-Q2"))
Your help is much appreciated!