G
Guest
I have two rows with three columns, the first row has 3 numbers in 3 columns,
the 2nd row only has 1 number in the 2nd column, if i average 1st row, then
average 2nd row, the total of these two average numbers doesn't tie to
average the whole area (1st cell of 1st row to 2nd row last column).
Is there a way to solve the difference, I need the separate average for each
row, then I bring them to a report, the report will sum the two average
together with a formula, also it average the whole data area in a separate
section, these two average need to be same.
the 2nd row only has 1 number in the 2nd column, if i average 1st row, then
average 2nd row, the total of these two average numbers doesn't tie to
average the whole area (1st cell of 1st row to 2nd row last column).
Is there a way to solve the difference, I need the separate average for each
row, then I bring them to a report, the report will sum the two average
together with a formula, also it average the whole data area in a separate
section, these two average need to be same.