Thank you Albert and Buddy! Why didn't I think of that? It works beautifully!
Cheryl -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Tuesday, September 13, 2005 3:55 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Controlling how an average is calculated when eliminating one or more values Try this: AVGBLK = (( + (IFNULL(BLK1,0,BLK1)) + + (IFNULL(BLK2,0,BLK2)) + + (IFNULL(BLK3,0,BLK3))) / + ((IFNULL(BLK1,0,1)) + + (IFNULL(BLK2,0,1)) + + (IFNULL(BLK3,0,1)))
