I want to average three cells and use the average to multiply with another cell.
Total these column as sums and then divide the final sums by each other. It will be great if someone can help.
Explaining this further:
First I need to average some cells. Then I have to multiple the average with another cell. Then I have to sum the entire column of the resulting cell. Then I have to sum another column and then divide these to resulting sums. Normally I would have to create hidden columns for this and have individual formulas to get the result. But I feel sumproduct can do this without creating columns.