Auto Increment

[Ragarm13]

I have this formula, =SUMIFS($D30:$D100,$C30:$C100,4,$F30:$F100,2), where I want only the number 4 to increment when i drag across a row.
I am unsure how to make this happen.

Heath

 

[Marcílio_Lobão]

Ragarm13, Good morning.

Try to use:

[COLOR=#333333]=SUMIFS($D30:$D100,$C30:$C100,[/COLOR][B][COLOR=#ff0000]ROW($A4)[/COLOR][/B][COLOR=#333333],$F30:$F100,2)[/COLOR]

Is that what you want?

I hope it helps.

 

[Ragarm13]

What I'm asking may not be possible, but the 4 is not a reference to a cell.

Ragarm13, Good morning.

Try to use:

[COLOR=#333333]=SUMIFS($D30:$D100,$C30:$C100,[/COLOR][B][COLOR=#ff0000]ROW($A4)[/COLOR][/B][COLOR=#333333],$F30:$F100,2)[/COLOR]

Is that what you want?

I hope it helps.

 

[MARK858]

I think you need

=SUMIFS($D30:$D100,$C30:$C100,COLUMN(D$1),$F30:$F100,2)

If you want to "increment when i drag across a row".
Please note that COLUMN(D$1) returns the number 4 not a cell reference.

 

[Marcílio_Lobão]

Ragarm13,

Have you tested whether the formula does what you want?

The Row($A4) function acts as an automatic numerator.

Please, test the suggested formula and then tell us if it worked the way you wanted it to.

 

[MARK858]

@ Marcílio_Lobão, the original post still says "increment when i drag across a row" not down the column

 

[Marcílio_Lobão]

MARK858, Good morning.

You're absolutely right.
I reversed the direction of the function.


Your formula uses the function appropriate for the user's request.

Thank you for the warning.


Have a nice day!

 

[MARK858]

Probably more appropriate if I had put

=SUMIFS($D30:$D100,$C30:$C100,COLUMNS($A$1:D$1),$F30:$F100,2)

though

 

[Ragarm13]

@MARK858 and @Marcílio_Lobão, thank you both for this information. MARK858, this work perfectly, thank you. I did not realize that the formula =COLUMN(??) returned an actual numeric value.

I think you need



If you want to "increment when i drag across a row".
Please note that COLUMN(D$1) returns the number 4 not a cell reference.