Home |
Search |
Today's Posts |
#1
|
|||
|
|||
what's the closest think to an "average if" function?
I have some data that I like to select and deselect using 1 or 0,
respectively. I'd like to look at the average of the values of the numbers I select using 1. Essentially, I am looking for an "averageif" function. |
#2
|
|||
|
|||
try something like this. This is an array formula which must be entered
using ctrl+shift+enter. =average(if(a2:a200=1,b2:b200)) -- Don Guillett SalesAid Software "Flutie99" wrote in message ... I have some data that I like to select and deselect using 1 or 0, respectively. I'd like to look at the average of the values of the numbers I select using 1. Essentially, I am looking for an "averageif" function. |
#3
|
|||
|
|||
Hi
P.e. with data you want to calculate the average of in range A2:A100, enter into some cell not on same row with your data (p.e. you can use additional rows in table header for it) the formula: =SUBTOTAL(1,A2:A100) Now use autofilter to filter all check values equal to 1, and you'll get the average of filtered data returned by formula. Arvi Laanemets "Flutie99" wrote in message ... I have some data that I like to select and deselect using 1 or 0, respectively. I'd like to look at the average of the values of the numbers I select using 1. Essentially, I am looking for an "averageif" function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions |