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)

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”