Can you do a average with criteria from another column?

Originally Posted by dredd2525

woot, granted some momentary inteligence. thank you to gorgette for the formula I got to work.

=SUMIF($I:$I,MONTH(NOW())-3,K:K)/COUNTIF($I:$I,MONTH(NOW())-3)

perfect and simple solution, thank you!!