An Average IF problem
Posted by Tanya on August 13, 2001 10:52 PM
I have run into a brick wall, and was wondering if someone could
just point me in the right direction. I have week numbers in one
column, dates in a column, and response time in another column.
What I need to do is this:
If the date column is blank, then I want the average of the
response time column cells that correspond to week 1.
My basic issue is that I have a log of all incoming and
outgoing requests, along with the response time for each
request. I need weekly counts of incoming, outgoing, and
the average response time. Any ideas on the direction that I
can take to do this?