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.

Try:

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


"carl" wrote:

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.

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

--
HTH

Bob Phillips

"Duke Carey" wrote in message
...
Try:

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


"carl" wrote:

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.