SUMIF Conidtions

[hamblin.adam]

=SUMIF($F$6:$F$2000,$O8,$G$6:$G$2000)*AND($M$6:$M$2000<=60)

This formula is ignoring the last AND statement...Please Help


Thanks
Adam

 

[PCLIVE]

See if this is what you want:

=SUMPRODUCT(--($F$6:$F$2000=$O8),--($M$6:$M$2000<=60),$G$6:$G$2000)

Regards,
Paul