Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 273
Default 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))
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default sumif date is greater than or equal chosen date

If both S6:S1147 and E3 contain full dates then your formula compares full
dates to month numbers that of course gives a wrong result. Try to omit MONTH
from your formula:

=SUMPRODUCT(--(T6:T1147="Sent TP"),--(S6:S1147=E3))

Regards,
Stefi

€˛Gary€¯ ezt Ć*rta:

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))

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 747
Default sumif date is greater than or equal chosen date

Try this

=COUNT(IF((T6:T42="sent TP")*(MONTH(U6:U42)=MONTH(E1)),U6:U42,""))

once u enter the formula use ctrl + shift + enter


On Sep 19, 1:37*am, Gary wrote:
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))


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting for cell date to equal today's date Sistereinstein Excel Worksheet Functions 2 September 10th 12 07:53 PM
Sumif....date in table is greater than compared to date [email protected] Excel Discussion (Misc queries) 1 September 13th 08 05:44 PM
Minimum Date Greater Than Observation Start Date vito Excel Discussion (Misc queries) 2 August 14th 07 03:02 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 03:06 AM
Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 7th 04 11:50 PM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"