Here are some methods to get a count and total from a list that’s to be written to Excel. Then add that list to the front using List.AddItemToFront .
(Edit: image updated)
I don’t think you can do it this way. The way Dynamo interops with Excel is that values written to cells are formatted as Strings. I would be surprised if that worked for setting the Formula. If you were to add a formula to a range would need a method called Range.Formula = “=SUM(B2:B4)” or whatever that formula was. Give it a try, but I am not sure that’s possible with the OOTB nodes.
It totally works. I was sharing what I learned.
oh nice, I didn’t think that Excel was that smart to pick it out, but i guess I was wrong. Nice one!
Here is a working sample. It uses Bumblebee, too.
Published as a Package: “Excel Sum String”
