| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif date is greater than or equal chosen date
I posted this question and received a response by email but couldn't find it
in the answers. My goal is to count the number of occurrences in T6 thru T1147 when a date in S6 thru S1147 corresponds to the words "Sent TP" in column T having a corresponding date that is greater or equal to a date in E3. E3 will contain a date equal to the first day of the month being tested and is in the format mm/dd/yyyy. So my goal is to count the number of occurences of "Sent TP" in column T that occur in any particular month E3 in column S. I tried this but it doesn't work: =SUMPRODUCT(--(T6:T1147="Sent TP"),--(MONTH(S6:S1147)=E3)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Sumif....date in table is greater than compared to date | Excel Discussion (Misc queries) | |||
| Minimum Date Greater Than Observation Start Date | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
