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!
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks