Hello,

I'm learning some stuff about excel and I came across the usage of the Offset function to some specific data into dynamic data. So the function example is this one: OFFSET(DynamicRangeSum!$C$5;0;0;1;COUNTA(DynamicRangeSum!$C$5:$M$5)).
How can this function get the values from a dynamic range if we're limiting its range to C5:M5?