T
Thomas Flake
If I have a list of dates and states as follows:
a b
1 date result
2 4/1/2005 excellent
3 4/1/2005 excellent
4 4/2/2005 excellent
5 4/3/2005 very good
6 4/4/2005 excellent
7 4/4/2005 good
8 4/4/2005 excellent
9 4/5/2005 excellent
10 4/5/2005 excellent
x y
1 excellent =countif(a1:b5,x1)
This will return the count of the days on which I received an excellent. In
this case 3.
Similarly I can use dcounta
x y z
1 date result count
2 4/5/2005 excellent =dcounta(a1:b10,"excellent",x1:y2)
This will give me a count of the number of times that I received an
excellent on that day. In this case 2.
My question is how do I essentially combine the two functions so that I can
get a count from a list where I have to meet multiple criteria?
In my example, the desired result would be the count of excellents for each
day:
p q
1 4/1/2005 2
2 4/2/2005 1
3 4/3/2005 0
4 4/4/2005 2
5 4/5/2005 2
Thanks in advance for any help.
a b
1 date result
2 4/1/2005 excellent
3 4/1/2005 excellent
4 4/2/2005 excellent
5 4/3/2005 very good
6 4/4/2005 excellent
7 4/4/2005 good
8 4/4/2005 excellent
9 4/5/2005 excellent
10 4/5/2005 excellent
x y
1 excellent =countif(a1:b5,x1)
This will return the count of the days on which I received an excellent. In
this case 3.
Similarly I can use dcounta
x y z
1 date result count
2 4/5/2005 excellent =dcounta(a1:b10,"excellent",x1:y2)
This will give me a count of the number of times that I received an
excellent on that day. In this case 2.
My question is how do I essentially combine the two functions so that I can
get a count from a list where I have to meet multiple criteria?
In my example, the desired result would be the count of excellents for each
day:
p q
1 4/1/2005 2
2 4/2/2005 1
3 4/3/2005 0
4 4/4/2005 2
5 4/5/2005 2
Thanks in advance for any help.