Question

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

  • 28 September 2021
  • 0 replies
  • 18 views

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


This topic has been closed for comments