I have a long irregular list of cells that repeat every 6 lines.
Like this:

Title
blank line
1st shift sales
2nd shift sales
3rd shift sales
blank line

repeat

I can build up a formula like this:
=concatenate("=Sum(B",C14,":B",C15,")")
where C14="3" and C15="5" for a complete formula of =Sum(B3:B5) to
calculate the days sales
now,. how can I get it from a text form to an executable form?

(Incidentally, when I use the concatenate operation shown above, Excel
rips off the last closing parend for some reason.)

Thanks