Download the workbook here
[ Ссылка ]
When you are working with Tables in Excel and you need to copy of drag the formula, unless you lock in your columns, when you drag your formula, the column references will move relative to the position of the formula. In this example, a user's SUMIFS function was not working and in this video, I explain why it does not work and how to overcome the problem by making cell and column reference absolute where necessary.
In this video, I also provide two alternative solutions that the user could try. One using Pivot tables and the other using Dynamic arrays.
If you want to learn more about Excel I hope you will visit our website
[ Ссылка ]
Sign up for our newsletter
[ Ссылка ]
Watch more Excel Videos
[ Ссылка ]
-------------------------------------------------------------------------------------------
