Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count items when specific text and date criteria are met
Trying to summarize survey data and need to report the number of
specific text responses given before a date and report those given on/after a date. The date and response information is contained in one worksheet while the summary is displayed in another worksheet within the same workbook (Excel 2000, Win XP). I've named the data ranges in an attempt to make this easier. For example: "TDate" "TQ7" 10/11/2004 q7= very easy 11/12/2005 q7= fairly easy 12/14/2004 q7= difficult I'm trying this formula to get a count of all the question 7 responses on/after the date: =SUMPRODUCT(("Tdate"=DATEVALUE("01/25/2005"))*("TQ7"<"")) I'm trying this formula to count specific responses by date: =SUMPRODUCT(("Tdate"=DATEVALUE("01/25/2005"))*(COUNTIF(TQ7,"*very easy")) To make things even stranger, I've "created" the date for "TDate" by calculating information from 3 other columns using the following formula (the date information is buried in a field with lots of other stuff so this is my attempt to isolate it): =DATE(D2,B2,C2) Not sure if this date approach causes a problem with calculations or if my formulas are just completely off base. Help greatly appreciated! Trish |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
How do I count items within a date range in Excel? | Excel Worksheet Functions | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions |