When I select the merged cells, they come up as A120:B124. Not all cells in columns A and B are merged, just the ones that are in my range.

As for using x...I am creating a form for others to fill in, thus I don't know which rows will be designated "individual training" as of yet (they have the option of 4 different pull downs). I want to be able to average the ones that they designate as individual training so I can't predetermine what rows need an "x"