Imagoodwon
New Member
- Joined
- Jan 14, 2010
- Messages
- 17
How can I rewrite this SumIF =SUMIF(A$2:A$1760,AY2,U$2:U$1760)
so that the A$1760 & U$2:U$1760 is NOT hard coded, but sets the range from A2 to the last used cell in Column A and Column U.
Thanks.
so that the A$1760 & U$2:U$1760 is NOT hard coded, but sets the range from A2 to the last used cell in Column A and Column U.
Thanks.