Re: Match, Filter????

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


.