| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 creteria one Name one DAte
rIn a previous post JMB said:
How many sales Brian had in January (2): =SUMPRODUCT(--(A1:A5="Brian"),--(MONTH(B1:B5)=1)) I have a similar problem and have tried this: =SUMPRODUCT(--(T6:T1147="Sent TP"),--(MONTH(S6:S1147)=E3)) 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF with 2 creteria one Name one DAte
Try like this:
=SUMPRODUCT(--(T6:T1147="Sent TP"),--(MONTH(S6:S1147)=MONTH(E3))) "Gary" wrote: rIn a previous post JMB said: How many sales Brian had in January (2): =SUMPRODUCT(--(A1:A5="Brian"),--(MONTH(B1:B5)=1)) I have a similar problem and have tried this: =SUMPRODUCT(--(T6:T1147="Sent TP"),--(MONTH(S6:S1147)=E3)) 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif date is greater than or equal chosen date | Excel Discussion (Misc queries) | |||
| Sumif....date in table is greater than compared to date | Excel Discussion (Misc queries) | |||
| How to use the IF function to resolved more than one creteria | Excel Worksheet Functions | |||
| SUMIF with 2 creteria one Name one DAte | Excel Discussion (Misc queries) | |||
| Can I use more complex logical expression for sumif as creteria? | Excel Worksheet Functions | |||
Linear Mode
