formula to average of a normalized measurement, dynamic to an input selection?

[surfer349]

So I'm trying to figure out a formula to give me the average of a group of runs by step after each run is normalized, dynamically, given the test you are interested in.

so each Measurement needs to be normalized by # of points = (Measurement/#points)
then i need to average all the runs in a given step.
I tried "AVERAGEIF" but I don't know how to put a normalization inside of of.

Any advice?

example of data attached

crossposted here.
https://www.mrexcel.com/board/thread...1141323/page-2

**edit, adjusted file attach**

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[surfer349]

thank you for the help. I attached a sample version.

what do you think?

[AliGW]

Which version of Excel are you using?

[bebo021999]

"I tried "AVERAGEIF" but I don't know how to put a normalization inside of of." what do you mean in bolded part?
I saw you do average correctly for step 1 in, i.e, cell R4=0.0582. What do you expect for cell, R4, to be? and how to calculate?

[surfer349]

"I tried "AVERAGEIF" but I don't know how to put a normalization inside of of." what do you mean in bolded part?
I saw you do average correctly for step 1 in, i.e, cell R4=0.0582. What do you expect for cell, R4, to be? and how to calculate?

*note i updated the file attach to be a bit more clear*
The attached file is the ideal state, so R4 is is the average of runs of normalized data for step#1 Param#1.
So for example:
- each Param has a measured value from a QTY of things.
- This Param value needs to be 'normalized,' meaning divide the value by the QTY.
- Each Step# is run several times to collect multiple measurements.
- I need to output the average of the normalized run data.

[surfer349]

Which version of Excel are you using?

excel 2016

[bebo021999]

If I understood correctly:
R4 outcome is exactly what you want
Normalizing table is helper table, now you want to eliminate it, and R4 is expected to refer directly to Source Data?

Is it true?