Excel - Creating pivot table with dynamic range

Short video shows how to effectively create pivot table based on named range to have it dynamic using OFFSET and COUNTA function.
Creating pivot table from dynamic named range helps to avoid count values instead of sum values.