Average

[How_Do_I]

Hello, I have something like the sample but a lot more columns with differing amounts of rows. What would be the formula in A1 to drag across to average the columns please?

There will be no blanks and no zeros in the columns. So I'm after a formula that combines AVERAGEIF(S) with INDEX or LOOKUP.

Oh, I forgot to mention, the rows in the columns expand as data is added elsewhere in the workbook

Sheet1

	A	B

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "] [/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: right"]1:05:03[/TD]
[TD="align: right"]0:56:28[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]0:50:44[/TD]
[TD="align: right"]0:40:08[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]1:01:48[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Tetra201]

Maybe just

=AVERAGE(A2:A100000)