Hi,
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
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