Created
February 13, 2022 22:29
-
-
Save Omid-M22/7fc1d6defa8b2fac90dd66ce55591014 to your computer and use it in GitHub Desktop.
Easily extraction of sum (or average or min or .....) of data based on special column in excel by Lambda function
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Extract_sum_of_Criteria= LAMBDA([Criteria column], [numerical column], | |
IF( | |
ISODD( | |
SEQUENCE( | |
COUNTA( | |
UNIQUE( | |
[Criteria column] | |
) | |
), | |
2 | |
) | |
), | |
UNIQUE( | |
[Criteria column] | |
), | |
SUMIFS( | |
[numerical column], | |
[Criteria column], | |
UNIQUE( | |
[Criteria column] | |
) | |
) | |
) | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment