Forum Discussion
How to select specific cells among thousands of cells that are in one column?
Hello All, Just in summary of the problem i am having is as follows: - I have one column that contains thousands of cells (data); - what i want to achieve is the average of some specific cells ...
Next to your data, in column B, starting from cell B1, enter this formula:
=IF(ISERROR(MATCH(ROW(),$C$1:$C$2762,0)),0,1)
COpy down to match the data in col A.
In Any cell, enter this formula to average the numbers:
=AVERAGEIF(B1:B48482,1,A1:A48482)
=IF(ISERROR(MATCH(ROW(),$C$1:$C$2762,0)),0,1)
COpy down to match the data in col A.
In Any cell, enter this formula to average the numbers:
=AVERAGEIF(B1:B48482,1,A1:A48482)