| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text from one column into multiple columns | Excel Discussion (Misc queries) | |||
| Data Text to Columns | Excel Discussion (Misc queries) | |||
| splitting text to multiple columns | Excel Discussion (Misc queries) | |||
| Delete Columns not Containing Certain Text | Excel Worksheet Functions | |||
| Convert text to dates | Excel Worksheet Functions | |||
Threaded Mode
