AVERAGE a range in a column if another column's range equals a val
AVERAGE a range in a column if a a value in a different column equals "1"
|
AVERAGE a range in a column if another column's range equals a val
Have you tried SUMIF / COUNTIF ?
hth, jay |
AVERAGE a range in a column if another column's range equals a val
Try this array formula** :
=AVERAGE(IF(A1:A10=1,B1:B10)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "bob$" wrote in message ... AVERAGE a range in a column if a a value in a different column equals "1" |
AVERAGE a range in a column if another column's range equals a val
Hi,
In 2007: =AVERAGEIF(D1:D4,1,A1:A4) Where D1:D4 contain the numbers you are looking for and you want to average A1:A4. In 2003: =SUMIF(A1:A8,1,B1:B8)/COUNTIF(A1:A8,1) in this case the 1's are in column A and the numbers you want to average in B. -- If this helps, please click the Yes button Cheers, Shane Devenshire "bob$" wrote: AVERAGE a range in a column if a a value in a different column equals "1" |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com