Try

=AVERAGE(IF((K2:K300="Incident")*(X2:X300<"Cancel led"),G2:G300))



--


Regards,


Peo Sjoblom


"Leonhardtk" wrote in message
...
Perfect. But I forgot to include one piece. I also need to filter out
rows
that have a value in X2:X300.

Eventually need to formula:

1. Average all the colums in G2:G300 where the value in K=TRUE and value
in
X <"Cancelled"
2. Average all the colums in G2:G300 where the VALUE in K<TRUE and value
in X<"Cancelled"

Thanks again,

KSL.

"JE McGimpsey" wrote:

One way (per your simplified example), array-entered (CTRL-SHIFT-ENTER
or CMD-RETURN):

=AVERAGE(IF(K1:K300=TRUE,G1:G300))


In article ,
Leonhardtk wrote:

I have a Column G2:G300, which contains the difference between dates.

What I need to do is average only rows that have certain values.

To simplify, I K2:G300 only contains two values (True and False)
How do I do an Average of all the columns (G2:G300) where the value in
"K"
for that row equals True. I then need to have a seperate average for
the
rows that contain False.

Appreciate any help on this.

KSL