Home |
Search |
Today's Posts |
#1
|
|||
|
|||
'Average' Function on 1500 lines
I'm creating a price list and need to have an average price list out of 6 prices on the end end of each line for about 1500 lines. Individually doing this would take a long time, any tips? -- Logan ------------------------------------------------------------------------ Logan's Profile: http://www.excelforum.com/member.php...o&userid=23729 View this thread: http://www.excelforum.com/showthread...hreadid=374027 |
#2
|
|||
|
|||
Assuming Columns A through F contain your prices, try... G1, copied down: =AVERAGE(A1:F1) Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=374027 |
#3
|
|||
|
|||
Logan wrote:
I'm creating a price list and need to have an average price list out of 6 prices on the end end of each line for about 1500 lines. Individually doing this would take a long time, any tips? If your pricing is in col A to F in col G put =Average(A1:F1) and copy it down col G by grabbing the lower right hand corner. gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using The Average Function if a cell has NA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
average function in Excel 2002 | New Users to Excel | |||
I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions |