Multiple COUNTIF and MONTH

[kerlj001]

I need some help with an excel formula pleas:

=SUMPRODUCT(--(RAW!$R$3:$R$20000="RESPOND"),--(RAW!$I$3:$I$20000=B4),--( RA W!$S$3:$S$20000="MADE"))


which searches the RAW tab and counts the number of rows where all 3 arrays are met. This works fine.

I need to now added another array to search column T (Dates dd/mm/yyyy) for all the above AND where the /mm/ part of the date = 12 (for example)

I tried this but n luck
=SUMPRODUCT(--(RAW!$R$3:$R$20000="RESPOND"),--(RAW!$I$3:$I$20000=B3),--( RA W!$S$3:$S$20000="MADE"),--(MONTH(RAW!$Q$3:$Q$20000=12)))


Any Ideas please, its driving me mad!

Thnx, Jody

 

[VoG]

Mis-placed closing parenthesis

=SUMPRODUCT(--(RAW!$R$3:$R$20000="RESPOND"),--(RAW!$I$3:$I$20000=B3),--( RA W!$S$3:$S$20000="MADE"),--(MONTH(RAW!$Q$3:$Q$20000)=12))

 

[kerlj001]

Thanks but it still returns 0? Is it the CTRL+HIFT+ENTER thing?

 

[VoG]

That is a regular formula, you don't need CSE.

 

[kerlj001]

Thanks - so why doesnt it work i wonder?

 

[Jonmo1]

I need some help with an excel formula pleas:

=SUMPRODUCT(--(RAW!$R$3:$R$20000="RESPOND"),--(RAW!$I$3:$I$20000=B4),--( RA W!$S$3:$S$20000="MADE"))


which searches the RAW tab and counts the number of rows where all 3 arrays are met. This works fine.

I need to now added another array to search column T (Dates dd/mm/yyyy) for all the above AND where the /mm/ part of the date = 12 (for example)

I tried this but n luck
=SUMPRODUCT(--(RAW!$R$3:$R$20000="RESPOND"),--(RAW!$I$3:$I$20000=B3),--( RA W!$S$3:$S$20000="MADE"),--(MONTH(RAW!$Q$3:$Q$20000=12)))


Any Ideas please, its driving me mad!

Thnx, Jody

In your description of your question, you said you wanted to check dates in column T
But in your formula you've used Column Q
Which is it?

Vogs formula works, perhaps you just need to change it to look at the correct column for the dates.

 

[kerlj001]

Apologies - forget Column T - It is Q. It doesnt work? does UK/US Date format matter?

TIA

 

[VoG]

The date format doesn't matter but the dates must be Excel dates. What does

=ISNUMBER(Q3)

return?

 

[kerlj001]

False?

Tia

 

[VoG]

So they are not Excel Dates. please post a few examples of what you have in column Q.