M Kan -
I've seen the SumProduct() function used a lot with the "--" (double minus),
what does that do? When I have used it it seems to ignore any values that
occur within that array, is it just telling Excel to treat it as a condition,
rather than useable values?

Thanks, Jim

"M Kan" wrote:
=SUMPRODUCT(--(MONTH($C$3:$C$46)=F3))