Hi,
I have a sheet similar to the following:
I would like to count all the events under the "Key" column containing the letter "a" (ie "*a*") taking place before date "1/1/1997". I tried nesting sum(if(range, criteria), but cannot make it accept the wildcard (*).
Thanks
I have a sheet similar to the following:
ESWL_1.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Occ | Key | |||
2 | 1/1/1985 | 1 | ab | |||
3 | 1/1/1986 | 1 | ac | |||
4 | 1/1/1987 | 1 | b | |||
5 | 1/1/1988 | 2 | d | |||
6 | 1/1/1989 | 1 | e | |||
7 | 1/1/1990 | 4 | a | |||
8 | 1/1/1991 | 1 | dc | |||
9 | 1/1/1992 | 2 | b | |||
10 | 1/1/1993 | 1 | ba | |||
11 | 1/1/1994 | 3 | c | |||
12 | 1/1/1995 | 1 | d | |||
13 | 1/1/1996 | 1 | e | |||
14 | 1/1/1997 | 1 | f | |||
15 | 1/1/1998 | 5 | fd | |||
16 | 1/1/1999 | 1 | dc | |||
17 | 1/1/2000 | 6 | af | |||
Sheet1 |
I would like to count all the events under the "Key" column containing the letter "a" (ie "*a*") taking place before date "1/1/1997". I tried nesting sum(if(range, criteria), but cannot make it accept the wildcard (*).
Thanks