Repeating formulas for an enitre column

[cheri]

I have a column of cells, say 34 rows. I am trying to get the results from comparing row 1:2 if it equals greater than zero, row 3:4 if greater than zero, etc. I have the "sumif" formula correct to get my result. My question is how do I repeat the formula I entered to compare the series of 2 rows for the entire column (example f2:f34) without manually entering each row number. Is there a function that will repeat my formula for the enitre range of the column?

 

[Frank Kabel]

Hi
not really sure what you're trying to achieve. could you post an
example (plain text please) and explain your expected result?

 

[Earl Kiosterud]

Cheri,

I presume you want the difference of each row pair summed. For one
interpretation of your question:

=SUMPRODUCT((MOD(ROW(F1:F34),2)=1)*F1:F34 - (MOD(ROW(F1:F34),2)=0)*F1:F34)

For another:

=SUMPRODUCT(ABS(F1:F33*(MOD(ROW(F1:F33),2)=1)-F2:F34*(MOD(ROW(F2:F34),2)=0))
)

There may be others. There may also be a more straightforward way to do it.
You can paste these from here, but remove any line feeds that you may see.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I have a column of cells, say 34 rows. I am trying to get the results from

comparing row 1:2 if it equals greater than zero, row 3:4 if greater than
zero, etc. I have the "sumif" formula correct to get my result. My question
is how do I repeat the formula I entered to compare the series of 2 rows for
the entire column (example f2:f34) without manually entering each row
number. Is there a function that will repeat my formula for the enitre range
of the column?