Two questions - copying and averaging
 

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!

Two questions - copying and averaging
 

Try this:

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

Average column C where column B = 1.

Biff

"Beatrice" wrote in message
...
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!

Two questions - copying and averaging
 

Thanks!

Two questions - copying and averaging
 

You're welcome!

Biff

"Beatrice" wrote in message
...
Thanks!