increasing an arguement

P

paul/bones

I am using a sumproduct function to to get # of occurances of two specific
number combinations. This is the function I have implemented
=SUMPRODUCT(--($AL$9:$AL$2622=11),--($AM$9:$AM$2622=1)) and I do not how to
set up the arguements to increase when I drag the function into other cells.
Any help would be appreciated.
 
E

Elkar

Try using the ROW or COLUMN functions. For example, if your original formula
is placed in cell A9, and you want to copy downward, then write your formula
like this:

=SUMPRODUCT(--($AL$9:$AL$2622=ROW()+2),--($AM$9:$AM$2622=ROW()-8))

If you want to copy across rather than down, use COLUMN instead.

HTH,
Elkar
 
P

Peo Sjoblom

What do you want to increase and with how much?

If you replace 11 with ROWS($A$1:A11)
then when you copy the formula down it will return
11
12
13
and so on, same with 1

ROWS($A$1:A1)

copied down will return

1
2
3
etc

Regards,

Peo Sjoblom
 
Top