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.

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


"paul/bones" wrote:

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.

row(a11)
row(a1)

--
Don Guillett
SalesAid Software

"paul/bones" wrote in message
...
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.

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
"paul/bones" wrote in message
...
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.