Hi,

I am trying to copy a SUMIF formula across columns and would like the "criteria" to increase by row, not column.

Here is my formula:

=SUMIF($A:$A,A2,$B:$B)


How can I get the A2 to become A3, A4, etc.

Thanks!