=AVERAGE(IF((paste_data!CJ2:CJ2000=1)*(paste_data! B2:F2000<""),paste_data!B2:F2000))


"mparker" wrote:

Just one more questions, this equation seems to be calculating blanks as 0s
in the average. Any idea?

"T. Valko" wrote:

There's nothing wrong with the formula. Did you enter it as an array? What
specific error do you get?

--
Biff
Microsoft Excel MVP


"mparker" wrote in message
...
I am trying to create an average of a range of cells - B2:F2000 - but only
if
Column CJ is 1. I am also trying to inset this equation to a different
worksheet. The sheet with the data in it is called paste_data. Here is
the
equation I am trying to use but it results in an error.

=AVERAGE(IF(paste_data!CJ2:CJ2000=1,paste_data!B2: F2000))