Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
averaging data in multiple columns
I'm looking for a formula to lookup criteria in column A and average the
results in columns B, C, D, E, etc. For example I would like to know the average of how many "CATS" have been sold in a given year and I will be adding addtional months as time progresses and do not want to have to adjust my range or formula each time a new months worth of data is added. For example. column A column B column C column D column E DOGS 100 200 150 50 CATS 200 300 100 0 FISH 50 100 200 100 Any help is truly appreciated. Thanks, Brad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To count the data using multiple criteria in multiple columns | New Users to Excel | |||
averaging info from three columns | Excel Discussion (Misc queries) | |||
Excel - Averaging Over Multiple Workbooks | Excel Worksheet Functions | |||
Averaging Columns based on a Text String | New Users to Excel | |||
Averaging columns | New Users to Excel |