increasing an arguement

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

Guest

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
 
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
 
Back
Top