One way ..
Put in C1: =ROW()
Put in D1, and array-enter (press CTRL+SHIFT+ENTER):
=AVERAGE(IF(($B$1:$B$200<"")*($A$1:$A$200=C1),$B$ 1:$B$200))
Select C1:D1, copy down to D7
D1 to D7 will return the results
for the corresponding day of week listed in C1:C7
(You'd get the full list for days 1 - 7)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Cheese" wrote in message
...
This is for Excel 2000.
I want to compute averages based on the day of the week listed in another
column but within the same row. I already have the day of the week figured
out, column A has numbers 1-7, 1=Sunday, 2=Monday, etc.
What I want is to take the AVERAGE of B1:B200, *if* the value in column
A=1,
or whatever number or numbers I specify.