making only certain numbers increment in formula

[TiggerTwo]

Hi, I have the following formula:
=SUMIF(DOME!E198:IE234,1,DOME!F196:F232)

I would like to just copy and drag down a column, and have only th
middle number increment by 1.

But currently when I click and copy/drag down the column, all number
change! ugh!

How do I change that?

I have a column of about 200 numbers and I don't want to go throug
each row manually pasting the same code and then manually changing th
middle number.

thanks
Bar

 

[Vasant Nanavati]

Try:

=SUMIF(Sheet1!E$198:IE$234,ROW(A1),Sheet1!F$196:F$232)

 

[TiggerTwo]

ummm..its not working...

I have column v as a UPC code entry
Column w is a corresponding dollar amount

Column AZ is a list of UPC codes matching their products
Colum BB is the formula =SUMIF(V$4:V$5000,ROW(AZ),W$4:W$5000)


But when I enter an amount in Column W wtih the UPC code in column V
it doesn't add up in BB, I just get $0.00

did I miss something?
thanks
Bar

 

[David McRitchie]

AZ can't be a list

SUMIF(range,criteria,sum_range)

Range is the range of cells you want evaluated.
Criteria is the criteria in the form of a number, expression, or text that
defines which cells will be added. For example, criteria can be
expressed as 32, "32", ">32", "apples".
Sum_range are the actual cells to sum. The cells in sum_range are
summed only if their corresponding cells in range match the criteria.
If sum_range is omitted, the cells in range are summed.

Example
Suppose A1:A4 contain the following property values for four homes: $100,000, $200,000, $300,000, $400,000, respectively. B1:B4
contain the following sales commissions on each of the corresponding property values: $7,000, $14,000, $21,000, $28,000.
SUMIF(A1:A4,">160000",B1:B4) equals $63,000

--

 

[TiggerTwo]

er..... by "list" I meant that
column az has a bunch of numbers going down it. Sorry for th
confusion.

I have column v as a bunch of UPC code entries (sales of products
going down the column
Column w is a bunch of corresponding dollar amounts (how much th
product sold for, going down the column)

Column AZ is a bunch of UPC codes matching their products (I'm usin
this column as a reference)
Column BB is the formula =SUMIF(V$4:V$5000,ROW(AZ),W$4:W$5000)

the formula you gave me makes sense to me.
It tells me:
In relation to the cell I am currently in, to go and look at the rang
of cells between 4 and 5000 in column v, if the content in column
matches the content from AZ in the row I am currently in, then to ad
the content in column w for the range 4-5000 with the criteria met, an
put the answer here in the cell I am currently in.

Makes sense to me..but apparently not to the software....er....maybe
have that backwards....

all I get is $0.00

I see how the formula is not dependent on a specific UPC code in th
middle of the formula, but rather a generic "guide" referencing th
cell (row AZ) next to it.
but for some reason it doesn't work. what did I miss?

thanks
Bar