LAMBDA is absolutely brilliant, especially for really long formula, and it’s so much easier than using VBA functions. I have a really long formula SUMPRODUCT(LEN(Range) - LEN(SUBSTITUTE(Range, “*”,””))) which counts all the Asterisks within the given Range. With LAMBDA it is shortened to CountAsterisks(Range) making it easier to use repeatedly throughout the workbook.
Why did you use the sum() function in column C in the first minute? You didn't use it, or rather you summed one thing, but used '+' instead to do the sum. 🤷🏼. It's superfluous, you can remove it and A*B+A will give you the same result. Possibly you meant sum(A*B,A)?
LAMBDA is absolutely brilliant, especially for really long formula, and it’s so much easier than using VBA functions.
I have a really long formula SUMPRODUCT(LEN(Range) - LEN(SUBSTITUTE(Range, “*”,””))) which counts all the Asterisks within the given Range.
With LAMBDA it is shortened to CountAsterisks(Range) making it easier to use repeatedly throughout the workbook.
Why did you use the sum() function in column C in the first minute? You didn't use it, or rather you summed one thing, but used '+' instead to do the sum. 🤷🏼. It's superfluous, you can remove it and A*B+A will give you the same result. Possibly you meant sum(A*B,A)?
I’ve seen a lot of people do this “sum” thing, I think it used to be taught that way, but it never made any sense to me. I’ve even seen Sum(A1+B1)!