how to save a function to use in the future

Copper Contributor

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

@menaaileenic 

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.