Z
zp18
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
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