Two questions - copying and averaging

B

Beatrice

Hello! Is it possible to have a case automatically copy to a second sheet if
a certain value is added into one of the columns? So, I want all the cases
that have a 1 in column B to be automatically pasted into sheet 2. Is that
possible? If not, is there some way to automatically calculate the average
of all the 1s in a separate sheet without having to run a filter? Thanks!
 
T

T. Valko

Try this:

=SUMIF(B1:B10,1,C1:C10)/COUNTIF(B1:B10,1)

Average column C where column B = 1.

Biff
 
Top