how to save a function to use in the future

Occasional Visitor

I'm either trying to write a vba code to save this function to recall it in the future,


=ROUND(SUM(IF($A$50:$A$2205>= B$1, IF($A$50:$A$2205<=B$2, IF($C$50:$C$2205=$A3,$B$50:$B$2205,)))/1000),1)


or I want to know how to just save it an easier way without using macros.


I also tired saving it as a name, but it doesn't work. 


please help

2 Replies


You could enter the formula in a cell and enter a space " " before the formula.

space in front of formula.JPG

If you have access to 365, you could roll it into a LAMBDA and store it in the name manager.