COUNTIF With Multiple Dates, Columns and Text
 

I need to count a number of entries that are between two dates where that
data is stored in column A and also if the text value in column F is "yes".
I have a formula to count the entries between two dates and a formula to
count the entries for the text equal to "yes", but I cannot bring it together
to do both...any suggestions?

=COUNTIF('Student Listing'!$A$2:$A$300,"=10/1/04")-COUNTIF('Student
Listing'!$A$2:$A$300,"=10/31/04")

=COUNTIF('Student Listing'!$F$2:$F$300,"Yes")

Thanks!

=sumproduct(('Student
Listing'!$A$2:$A$300=datevalue("10/1/04"))*('Student
Listing'!$A$2:$A$300<=datevalue("10/31/04"))*('Student
Listing'!$F$2:$F$300="Yes")*1)

count of all occurances of yes between 10/1 and 10/31 inclusive

assumes the dates in column A are dates and not text


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=320505

One way

Try:

=SUMPRODUCT(('Student Listing'!$A$2:$A$300=DATE(2004,10,1))*('Student
Listing'!$A$2:$A$300<=DATE(2004,10,31))*('Student
Listing'!$F$2:$F$300="Yes"))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Shannon" wrote in message
...
I need to count a number of entries that are between two dates where that
data is stored in column A and also if the text value in column F is
"yes".
I have a formula to count the entries between two dates and a formula to
count the entries for the text equal to "yes", but I cannot bring it
together
to do both...any suggestions?

=COUNTIF('Student Listing'!$A$2:$A$300,"=10/1/04")-COUNTIF('Student
Listing'!$A$2:$A$300,"=10/31/04")

=COUNTIF('Student Listing'!$F$2:$F$300,"Yes")

Thanks!

Thanks! That did the trick. I appreciate all of the help.

"Max" wrote:

One way

Try:

=SUMPRODUCT(('Student Listing'!$A$2:$A$300=DATE(2004,10,1))*('Student
Listing'!$A$2:$A$300<=DATE(2004,10,31))*('Student
Listing'!$F$2:$F$300="Yes"))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Shannon" wrote in message
...
I need to count a number of entries that are between two dates where that
data is stored in column A and also if the text value in column F is
"yes".
I have a formula to count the entries between two dates and a formula to
count the entries for the text equal to "yes", but I cannot bring it
together
to do both...any suggestions?

=COUNTIF('Student Listing'!$A$2:$A$300,"=10/1/04")-COUNTIF('Student
Listing'!$A$2:$A$300,"=10/31/04")

=COUNTIF('Student Listing'!$F$2:$F$300,"Yes")

Thanks!

You're welcome !
Thanks for the feedback
--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"Shannon" wrote in message
...
Thanks! That did the trick. I appreciate all of the help.