Re: Match, Filter????

Are you really using the entire columns?

This formula will work but it will add to the calculation time that you
already mentioned is an issue:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=AVERAGE(IF((W2:W65535="Red")*(X2:X65535="Blue")*(Y2:Y65535="Yellow")*(Z2:Z65535="Green"),H2:H65535))

Biff

"M.A.Tyler" <Great Lakes State> wrote in message
news:08ABF801-83CA-438A-A146-F63DAEDCB045@xxxxxxxxxxxxxxxx
Need to Average cells H2:H65535, where corresponding cells in
W2:W65535="Red", X2:X65535="Blue", Y2:Y65535="Yellow" and
Z2:Z65535="Green".
Need to enter the formulas in Sheet2!S2:S100.

"T. Valko" wrote:

Try rephrasing your question in terms like this:

I need to average cells A1:A100 where the corresponding cells in B1:B100
=
"this", C1:C100 = "this", D1:D100 = "this".

Biff

"M.A.Tyler" <Great Lakes State> wrote in message
news:9F1A5178-D8AD-4663-8AC5-A50DE43081A0@xxxxxxxxxxxxxxxx
Hello,

I'm currently using page 1 of a work book as a data base. Not certain
thats
the best idea because opening, saving and calculating have become
slower
as
the information expands. This is not my real question, but any feed
back
will
be welcome.

So page 1 is the database, on page 2 some calculations. Would like to
include matching cells from column H that meet criterian held in
columns
W,
X, Y and Z (1 each). then I would need to add and average these cells.
Is
this possible to do in one step? Should I use a Index> Match or would a
filter be the way.

Thanks, as always for the help!

M.A.Tyler





.