Aggregating based on multiple conditions

[SiddharthK]

Hello all,

I am trying to summarise Value by IND (column B) and summarise in the 2nd table (columns F - column M). The query I am trying is to match 2 criteria - IND & Value <= value in column E. So , cell F3 & G3 has the count of values for Beta with Value <= 1.2 & Average Value for cases with Value <= 1.2. The main table is Table 1 (column - column C) and summary table is table 2 (columns F - column M). The table sample is as below.

Please help.

Regards

[TABLE="width: 865"]
<colgroup><col><col><col span="11"></colgroup><tbody>[TR]
[TD][/TD]
[TD]IND[/TD]
[TD]Value[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"] Beta[/TD]
[TD="colspan: 2"] Alpha[/TD]
[TD="colspan: 2"] Property[/TD]
[TD="colspan: 2"] Gamma[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alpha[/TD]
[TD="align: right"]2.7[/TD]
[TD][/TD]
[TD]Value[/TD]
[TD]Cnt N[/TD]
[TD]Avg Value[/TD]
[TD]Cnt N[/TD]
[TD]Avg Value[/TD]
[TD]Cnt N[/TD]
[TD]Avg Value[/TD]
[TD]Cnt N[/TD]
[TD]Avg Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Gamma[/TD]
[TD="align: right"]1.9[/TD]
[TD][/TD]
[TD]1.2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Gamma[/TD]
[TD="align: right"]1.8[/TD]
[TD][/TD]
[TD]1.3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alpha[/TD]
[TD="align: right"]1.8[/TD]
[TD][/TD]
[TD]1.4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alpha[/TD]
[TD="align: right"]2.6[/TD]
[TD][/TD]
[TD]1.5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Beta[/TD]
[TD="align: right"]2.5[/TD]
[TD][/TD]
[TD]1.6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Gamma[/TD]
[TD="align: right"]1.9[/TD]
[TD][/TD]
[TD]1.7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alpha[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]1.8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Gamma[/TD]
[TD="align: right"]2.4[/TD]
[TD][/TD]
[TD]1.9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Gamma[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]2.0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alpha[/TD]
[TD="align: right"]2.7[/TD]
[TD][/TD]
[TD]2.1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alpha[/TD]
[TD="align: right"]2.6[/TD]
[TD][/TD]
[TD]2.2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Gamma[/TD]
[TD="align: right"]2.3[/TD]
[TD][/TD]
[TD]2.3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]