Use a array formula:

=AVERAGE(IF(G6:G3270,K6:K327,""))

When you're done typing, press Ctrl+Shift+Enter.
--
Conrad S
#Don't forget to click "Yes" if this post was helpful!#


"Tflight" wrote:

Hi,

I am trying to find the average of the total number for all the cells that
in their row have a number that is greater than 0 in one of the categories.

The formula I sort of have is:
IF(G6:G3270),AVERAGE(K6:K327)

I just learned about the function sumproduct, but I'm not sure if it would
work in this case. I don't really understand the function anyhow. Any help
would be appreciated.