Oct 26 2022 08:28 AM
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
Oct 26 2022 08:36 AM
Oct 26 2022 11:51 AM - edited Oct 26 2022 01:05 PM
If you have access to 365, you could roll it into a LAMBDA and store it in the name manager.