Modify A SumProduct Formula

[Guest]

I currently use this formula:

=SUMPRODUCT(--($S$10:$S$60001=$H$2);$H$10:$H$60001)/$T$4

My ColS values are dates that look like so:

20050512 (year,month,day).

I would like to modify the formula to sum only if the 5th and 6th character
= 05.

Thank you in advance.

 

[Guest]

Try:

=SUMPRODUCT(--(MID($S$10:$S$60001,5,2)="05");$H$10:$H$60001)/$T$4

 

[Bob Phillips]

=SUMPRODUCT(--(MONTH($S$10:$S$60001)=5);$H$10:$H$60001)/$T$4