How to average values based on a condition in another column
=AVERAGE(IF(A1:A100<11,P1:P100))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Ken99" wrote in message
...
I have a spreadsheet with a number from 1-20 in column A for each record
(row). I have another number in column P representing a number of days
for
each record. I need a summary formula which does the following:
For all the rows in column A that are less than 11 (have values from
1-10),
average all of the matching rows in column P.
|