Greetings,

I have created two dynamic ranges, minutes and shift, using the Name manager. For the two ranges, the "refers to" field is as follows
=OFFSET(Sheet1!$A$2,0,0,COUNT(Sheet1!$A$2:$A$5000),1)
=OFFSET(Sheet1!$B$2,0,0,COUNT(Sheet1!$B$2:$B$5000),1)
My question is if I create a new third dynamic range called "result" with the following code..
=OFFSET(Sheet1!$C$2,0,0,COUNT(Sheet1!$C$2:$C$5000),1)
...how can I apply the formula A*B to the entire dynamic range C? That is, for every entry in A and B I want the result of A*B in C, and it needs to be dynamic so that if entries are added to a and b, the results are still reflected in C.

Thank you so much for the help!

-Willis