Repeating formulas for an enitre column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
not really sure what you're trying to achieve. could you post an
example (plain text please) and explain your expected result?
 
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
-------------------------------------------

cheri said:
I have a column of cells, say 34 rows. I am trying to get the results from
Click to expand...
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?
 
Back
Top