mballantyne
New Member
- Joined
- Oct 24, 2006
- Messages
- 6
I would like to count text using two different criteria. Ex: In the following example spreadsheet I would like a count of how many times John was "in".
Book2 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
3 | |||||||
4 | John | in | |||||
5 | John | out | |||||
6 | John | in | |||||
7 | John | in | |||||
8 | John | loa | |||||
9 | John | in | |||||
10 | John | out | |||||
11 | Jane | loa | |||||
12 | Jane | loa | |||||
13 | Jane | in | |||||
14 | Jane | in | |||||
15 | Mike | out | |||||
16 | Mike | in | |||||
17 | Mike | loa | |||||
18 | Mike | in | |||||
Sheet1 |