More help with SumProduct

[Bob Phillips]

Is this what you need?

=SUMPRODUCT(--(TEXT(NoRate_UnRate_Inspection_Dates,"mmmm")=$CU6),
                     --(NoRate_UnRate_Inspection_Dates>$CW$3),
                     --(NoRate_UnRate_Inspection_Dates<$CW$4))

[dragon]

Thanks xld,

I tried your formula and the value in CW6 evaluates to 0. I know that there is at least 1 instance of an inspection in January 2010 because of the date in AA28.

Could it be an error in my defined name range? I did a lot of fiddling around with that and am not confident I've defined it properly as don't fully understand about offsetting