MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help!!!


Posted by Steve on August 09, 2001 12:36 PM

Using this formula:

=countif(x:y,z)

need to add this to formula

average a

More info:

I have dates in a column, for each of the reoccuring dates, i need the average desplayed.

date number
10/1/00 53
10/1/00 0
11/1/00 -3
12/1/00 7
2/1/01 14
2/1/01 7
5/1/00 -288
3/1/01 14
7/1/01 126
5/1/01 84
3/1/01 -7
3/1/01 1
5/1/01 56
5/1/01 14
3/1/01 14
4/1/01 0
5/1/01 21
4/1/01 0
5/1/01 -11
6/1/01 8
7/1/01 2
6/1/01 0
7/1/01 14
7/1/01 21
6/1/01 -8
7/1/01 7
7/1/01 0


Posted by Aladin Akyurek on August 09, 2001 12:40 PM

Care to elaborate? I see 2 columns. Apparently you want to do an average, but average of what? Average of numbers that correspond between two dates or to a certain date in the first column?

Aladin

Posted by steve on August 09, 2001 12:56 PM

to difficult to explain completely, what is your E-Mail and ill send it to you.

Posted by steve on August 09, 2001 1:09 PM

6 c d e f g h I j
7
8
9 E11-Day(E11)+1 F11-E11 countif(F11:F37,H11)
10 Due Completed Norm-Comp Delta Dates Count per Month Average of delta here per month
11 9/1/00 10/24/00 10/1/00 -23 2/1/00 0
12 10/10/00 10/10/00 10/1/00 -9 3/1/00 0
13 12/1/00 11/28/00 11/1/00 -27 4/1/00 0
14 12/12/00 12/19/00 12/1/00 -18 5/1/00 1
15 2/6/01 2/20/01 2/1/01 -19 6/1/00 0
16 1/30/01 2/6/01 2/1/01 -5 7/1/00 0
17 2/27/01 5/15/00 5/1/00 -14 8/1/00 0
18 3/12/01 3/26/01 3/1/01 -25 9/1/00 0
19 3/6/01 7/10/01 7/1/01 -9 10/1/00 0
20 2/27/01 5/22/01 5/1/01 -21 11/1/00 0
21 3/13/01 3/6/01 3/1/01 -5 12/1/00 0
22 3/20/01 3/21/01 3/1/01 -20 1/1/01 0
23 3/6/01 5/1/01 5/1/01 0 2/1/01 0
24 5/15/01 5/29/01 5/1/01 -28 3/1/01 1
25 3/13/01 3/27/01 3/1/01 -26 4/1/01 2
26 4/3/01 4/3/01 4/1/01 -2 5/1/01 2
27 4/24/01 5/15/01 5/1/01 -14 6/1/01 3
28 4/23/01 4/23/01 4/1/01 -22 7/1/01 5
29 6/5/01 5/25/01 5/1/01 -24 8/1/01 0
30 6/12/01 6/20/01 6/1/01 -19 9/1/01 0
31 7/15/01 7/17/01 7/1/01 -16 10/1/01 0
32 6/12/01 6/12/01 6/1/01 -11 11/1/01 0
33 7/3/01 7/17/01 7/1/01 -16 12/1/01 0
34 6/26/01 7/17/01 7/1/01 -16 1/1/02 0
35 7/3/01 6/25/01 6/1/01 -24 2/1/02 0
36 7/3/01 7/10/01 7/1/01 -9 3/1/02 0
37 7/17/01 7/17/01 7/1/01 -16 4/1/02 0

Posted by Steve on August 09, 2001 1:10 PM

Ignore this!! Bad formating

Sorry bad format

Posted by Aladin Akyurek on August 09, 2001 1:17 PM

Re: Ignore this!! Bad formating

akyurek@xs4all.nl