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
...
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