Nested Countif

[gldurand]

Hi Team, I am trying to write a statement that would allow me to count the number of occurrences of the following information.

I need to count if Field A (text) = Yes, Field B (Text) = Yes and field C (Date) is between two specific dates.

I tried the following but does not work, i checked the result manually with filters and it does not match the formula result;

=SUMPRODUCT(--('Source Data'!$B$1:$B$544="Toronto"),--('Source Data'!$J$1:$J$544="Yes"),--('Source Data'!$F$1:$F$544<=2/3/2009))

Range B = TEXT
Range J = Text
Range F = Date

It is probably very easy, but my brain is fried.
Thanks

 

[Scott Huish]

You don't have a starting date in your formula so I picked 1/1/2009:

=SUMPRODUCT(--('Source Data'!$B$1:$B$544="Toronto"),--('Source Data'!$J$1:$J$544="Yes"),--('Source Data'!$F$1:$F$544>="1/1/2009"+0),--('Source Data'!$F$1:$F$544<="2/3/2009"+0))

This way it will coerce the text string to a date, the way you have it Excel will interpret that as 2 divided by 3 divided by 2009

 

[gldurand]

Hotpepper, thanks so much, it works, foolish me, should have come here after 1 hour of trying, My ego got to me

Thanks again