How do I calculate the average over some values defined in a row ? For example
H1 H2 Value
Ax || a1 || 1
Ay || a1 || 2
Az || a1 || 2
Ab || a2 || 2
Ac || a2 || 3
I need average for a1 that would be ( 1+2+2)/ 3 ( as there are three a1) . The hierarchal integrity should remain intact meaning the grouping is done based on top to bottom approach only need average based on H2. Basically same as the function in AVERAGEIF in Excel Spreadsheet