How to calculate mean over a custom row value something like AVERAGEIF in Excel Spreadsheet?

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

0 0 127
0 REPLIES 0
Top Labels in this Space
Top Solution Authors