Need Urgent Help, to a peculier problem.

In an Excel list example pasted here,

When i need to Calculate averages of coloumn 3 and 4 below based on coloumn 2, i use the following formula -

=(SUMIF($D$9:$D$27,"CDS",E9:E27))/COUNTIF($D$9:$F$27,"CDS")

"C" "D" "E" "F"

104 ABX 34 36

105 ABX 18 18

112 CDS 26 27

113 CDS 17 18

116 CDS 42 43

117 CDS 16 17

125 ABX 19 20

Using above formula i can display averages of both ABX and CDS in Two Rows.

Now the Problem arises when i want to use subtotals based on filters.

e.g to get an average of the whole coloum "E", i can easily type in

=Subtotal(1,D9:D27) and Get a result.

But as stated earlier i need to get individual averages for abx and CDS as well in two rows, when i custom filter lets say coloum "C" for range between 101 and 116.

Any help??

This message was edited by kahmad on 2002-09-19 07:40