calculate average in a column based on criteria in another column

Giganews Newsgroups
Subject: calculate average in a column based on criteria in another column
Posted by:  sharon t
Date: Fri, 12 May 2006

I want to calculate the average of numbers in one column based on crieteria
in another colume.

If the value in column A = x, sum and average the corresponding values in
column B

Replies