hi, tried that, did not seem to work, got a zero result: am trying to
Average every-other column only.. where array starts with AO to BH (not
sure if that matters), but e.g. numbers colums 1 2 3 4:

..0599
4000
..0539
53500

want to Average: .0599 & .0539, and: 4000 & 53500 separately. thanks.

"Bob Phillips" wrote:

=IF(AC49="","",AVERAGE(IF(MOD(COLUMN($AP49:$BH49), 2)MOD(COLUMN($AP49),2),$AP49:$BH49)))

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

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"nastech" wrote in message
...
Hi, I have an example for sumproduct, finding product for each 2 lines in
an
array.
for sumproduct, have example that works. if someone can tell what double
negs: "--" are for / how works with divisor / sometimes use "=" instead
of
"".. so can figure them out.. thanks

example sumproduct that works:

=IF(AC49="","",IF(AP49="",0,SUM(--(MOD(COLUMN($AP49:$BH49),2)MOD(COLUMN($AP49),2)), $AP49:$BH49)))


PROBLEM: Is there a way to find the average of just the 1st column, to
the
rest of the 1st columns, trying (guesse gets average of all columns?):

=IF(AC49="","",AVERAGE(--(MOD(COLUMN($AP49:$BH49),2)MOD(COLUMN($AP49),2)), $AP49:$BH49))