Hello!
I am trying to get an average of multiple columns based on the criteria from the previous cell. These are every other one, so I am having a hard time getting it to sort out the data. I need column BS to average all of the Strength Results of the cells that have a Cure Time of 28. See screenshot below. Would anybody be able to help me out? I have tried a combination of AVERAGE, IF, AVERAGEA, etc and can't seem to get it too work.
Thanks, Terence
I am trying to get an average of multiple columns based on the criteria from the previous cell. These are every other one, so I am having a hard time getting it to sort out the data. I need column BS to average all of the Strength Results of the cells that have a Cure Time of 28. See screenshot below. Would anybody be able to help me out? I have tried a combination of AVERAGE, IF, AVERAGEA, etc and can't seem to get it too work.
Thanks, Terence